mrudhula99 Posted February 4, 2013 Report Posted February 4, 2013 [quote name='pandemkodi' timestamp='1360014939' post='1303225288'] pmed mama ATB [/quote] congrats pandemkodi
qwerty1204 Posted February 5, 2013 Author Report Posted February 5, 2013 [quote name='pandemkodi' timestamp='1360012435' post='1303225021'] dude nenu employer ni kaadu ...nenu positions kosam choostey okati confirm iyyindi ..inka vunnai telisina vallu vuntey refer cheyyamandi enno project bayya needi [/quote] baa
pandemkodi Posted February 5, 2013 Report Posted February 5, 2013 [quote name='mrudhula99' timestamp='1360022201' post='1303226036'] congrats pandemkodi [/quote] [quote name='arey ooo samba' timestamp='1360026391' post='1303226305'] baa [/quote] thanks vayyas
qwerty1204 Posted February 5, 2013 Author Report Posted February 5, 2013 CDC Management Console ani oka tool undi kada IBM InfoSphere loo evaranna use chesara adhi...asalu emi emi cheyachu using that
soldier Posted February 5, 2013 Report Posted February 5, 2013 M99 & youth Excel help plzzzz Db2 command Editior nunchi data Export cheste Excel lo Date fields marutunayyiiii Like Query result 2-5-2013 untee adi Excel lo 2/5/2013 avutundii Alaaa kakundaaa em anaa options unnayii haaa? Manaki Excell bebe bebe
pandemkodi Posted February 5, 2013 Report Posted February 5, 2013 [quote name='arey ooo samba' timestamp='1360101434' post='1303231786'] CDC Management Console ani oka tool undi kada IBM InfoSphere loo evaranna use chesara adhi...asalu emi emi cheyachu using that [/quote] IBM infosphere CDC tool ki idi client mama ..like datastage ki designer client laa deenlo manam datastores and datastores lo subscriptions sub lo tables create cheyyochu for ex source oka database vudni teradata(employees anukundam) ...source db meeda cdc agent ni install chestadu Admin gaadu so when ever the data changes a CDC generates a flat file mama basci gaa adi change data capture ki seperate toolo anthey ....data lo before image and after image vastai and timestamps kuda vastai so we can wasily do incremental loading
qwerty1204 Posted February 6, 2013 Author Report Posted February 6, 2013 [quote name='soldier' timestamp='1360101844' post='1303231854'] M99 & youth Excel help plzzzz Db2 command Editior nunchi data Export cheste Excel lo Date fields marutunayyiiii Like Query result 2-5-2013 untee adi Excel lo 2/5/2013 avutundii Alaaa kakundaaa em anaa options unnayii haaa? Manaki Excell bebe bebe [/quote] may be manual ga nee convert chesukovali emo baa..after u generate the excel [quote name='pandemkodi' timestamp='1360101864' post='1303231857'] IBM infosphere CDC tool ki idi client mama ..like datastage ki designer client laa deenlo manam datastores and datastores lo subscriptions sub lo tables create cheyyochu for ex source oka database vudni teradata(employees anukundam) ...source db meeda cdc agent ni install chestadu Admin gaadu so when ever the data changes a CDC generates a flat file mama basci gaa adi change data capture ki seperate toolo anthey ....data lo before image and after image vastai and timestamps kuda vastai so we can wasily do incremental loading [/quote] oh kk...so tables anevi endhuloo create chesukovali aa leka already teradata lo create chesina tables ni endhuloo configure chesukovali aaa if configure chesukovali aite..after we configured...do we have the option to choose the SCD types (like SCD-1, SCD-2) on the table? finally aa flat file ni tesukoni manamu oka job design chesukovali aa..to load into the dimensions?
dalapathi Posted February 7, 2013 Report Posted February 7, 2013 Ee error ehdo torture pedtundhi[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] Stored_Procedure_30,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed. monna edho join stage lo vachindhi ... adhi peeki lookup stage vaadina ... ippudu stored procedure stage lo vastundhi[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]
Manthrii Posted February 7, 2013 Report Posted February 7, 2013 [quote name='dalapathi' timestamp='1360263150' post='1303242620'] Ee error ehdo torture pedtundhi[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] Stored_Procedure_30,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed. monna edho join stage lo vachindhi ... adhi peeki lookup stage vaadina ... ippudu stored procedure stage lo vastundhi[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] [/quote] dheniki edho config file vadali anukunta baa
dalapathi Posted February 7, 2013 Report Posted February 7, 2013 [quote name='Manthrii' timestamp='1360267535' post='1303243243'] dheniki edho config file vadali anukunta baa [/quote] enno google cheste edho maarvamani vunde buffer size ooh edho adhi maarchinam ayina nichange[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]
Manthrii Posted February 7, 2013 Report Posted February 7, 2013 [quote name='dalapathi' timestamp='1360267983' post='1303243304'] enno google cheste edho maarvamani vunde buffer size ooh edho adhi maarchinam ayina nichange[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] [/quote] buffer size ante scratch disk a dala!!
pandemkodi Posted February 7, 2013 Report Posted February 7, 2013 [quote name='arey ooo samba' timestamp='1360111098' post='1303232410'] may be manual ga nee convert chesukovali emo baa..after u generate the excel oh kk...so tables anevi endhuloo create chesukovali aa leka already teradata lo create chesina tables ni endhuloo configure chesukovali aaa if configure chesukovali aite..after we configured...do we have the option to choose the SCD types (like SCD-1, SCD-2) on the table? finally aa flat file ni tesukoni manamu oka job design chesukovali aa..to load into the dimensions? [/quote] just oka datastore create chestav cdc lo daanlo oka subscription pedtav ..danlo source tables ni add chestav inka table ni mirring mode o inko mode edo vuntadi daanlo pedtav..anthey data lo change vachinapudu adi automatic gaa files with before image and after image flatfiles generate chestadi mama...inka manam dtaging lo aa cdc lo vunna structure tho tables create chesi flat files ni staging lo load cheyyatmey... inka scd 1 or 2 edina stg to core load appudu chesko nuvvu
qwerty1204 Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='pandemkodi' timestamp='1360269152' post='1303243451'] just oka datastore create chestav cdc lo daanlo oka subscription pedtav ..danlo source tables ni add chestav inka table ni mirring mode o inko mode edo vuntadi daanlo pedtav..anthey data lo change vachinapudu adi automatic gaa files with before image and after image flatfiles generate chestadi mama...inka manam dtaging lo aa cdc lo vunna structure tho tables create chesi flat files ni staging lo load cheyyatmey... inka scd 1 or 2 edina stg to core load appudu chesko nuvvu [/quote] oh kk...so final core table lo ki load chese mundu weh have to handle aa aite based on our REQ
qwerty1204 Posted February 7, 2013 Author Report Posted February 7, 2013 [quote name='dalapathi' timestamp='1360263150' post='1303242620'] Ee error ehdo torture pedtundhi[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] Stored_Procedure_30,0: Operator terminated abnormally: Terminating with exception:APT_BadAlloc: Heap allocation failed. monna edho join stage lo vachindhi ... adhi peeki lookup stage vaadina ... ippudu stored procedure stage lo vastundhi[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img] [/quote] enni nodes medha run chestunaru baa mee ENV looo if its only 2..then may be you guys need to increase it.[img]http://lh3.ggpht.com/-8RwT8_LLHM4/UOoO_Lps31I/AAAAAAAAIyk/-Y1PHoxQ2yY/s150/Brahmi.gif[/img]
Recommended Posts