tom bhayya Posted March 8, 2013 Report Posted March 8, 2013 [quote name='Kaarthikeya' timestamp='1362754133' post='1303386413'] koddiga rammanu bhayya...ikkada chala doubts unnayi maaku [/quote] agreed
pandemkodi Posted March 11, 2013 Report Posted March 11, 2013 evarikina ee issue vachinda The array size must be set to 1 so that the connector can process LOB values in oracle connector nenu already array size 1 ichanu
pandemkodi Posted March 19, 2013 Report Posted March 19, 2013 vunnara evarina ....scd stage ki rendu o/p vunnai kada okati delta records istadi inko o/p em chestadi
dalapathi Posted March 19, 2013 Report Posted March 19, 2013 [quote name='pandemkodi' timestamp='1363736305' post='1303452948'] vunnara evarina ....scd stage ki rendu o/p vunnai kada okati delta records istadi inko o/p em chestadi [/quote] nenu aslau vaadale ippait varkau aah stage[img]http://i48.tinypic.com/28m2wqs.gif[/img]
pandemkodi Posted March 19, 2013 Report Posted March 19, 2013 [quote name='dalapathi' timestamp='1363736522' post='1303452957'] nenu aslau vaadale ippait varkau aah stage[img]http://i48.tinypic.com/28m2wqs.gif[/img] [/quote] nenu vadaley bayya but try chestunna ela work avudhi ani but artham iyyi savtla maa danlo chnage capture use chesi chstey performence issues antunnaru sodi gaallu
qwerty1204 Posted March 19, 2013 Author Report Posted March 19, 2013 [quote name='pandemkodi' timestamp='1363736305' post='1303452948'] vunnara evarina ....scd stage ki rendu o/p vunnai kada okati delta records istadi inko o/p em chestadi [/quote] inko o/p may be fact table update cheydaniki use chese records o/p cheyadaniki anukunta baa [img]http://i48.tinypic.com/28m2wqs.gif[/img]
dalapathi Posted March 19, 2013 Report Posted March 19, 2013 [quote name='pandemkodi' timestamp='1363736885' post='1303452972'] nenu vadaley bayya but try chestunna ela work avudhi ani but artham iyyi savtla maa danlo chnage capture use chesi chstey performence issues antunnaru sodi gaallu [/quote] ooh ... ok
pandemkodi Posted March 19, 2013 Report Posted March 19, 2013 [quote name='arey ooo samba' timestamp='1363737027' post='1303452981'] inko o/p may be fact table update cheydaniki use chese records o/p cheyadaniki anukunta baa [img]http://i48.tinypic.com/28m2wqs.gif[/img] [/quote] nenu incremental stg level lo chestunna ..i mean staging tables loki delta records load chestunnna ...appudu naaku oka main source(sql server idi after data..will be changing) and oracle (idi reference dtaa ....target idi deentho lookup chestunna so before dtaa idi) so naaku only stg table okkatey vundi upsert cheyytaniki ..ippudu inko op link paristhithi enti?
Manthrii Posted March 20, 2013 Report Posted March 20, 2013 [quote name='pandemkodi' timestamp='1363737404' post='1303453001'] nenu incremental stg level lo chestunna ..i mean staging tables loki delta records load chestunnna ...appudu naaku oka main source(sql server idi after data..will be changing) and oracle (idi reference dtaa ....target idi deentho lookup chestunna so before dtaa idi) so naaku only stg table okkatey vundi upsert cheyytaniki ..ippudu inko op link paristhithi enti? [/quote] [size=4] [/size][size=4] nerchukoni maku kuda knowledge transfer seyyi mama[/size]
dalapathi Posted March 20, 2013 Report Posted March 20, 2013 [quote name='pandemkodi' timestamp='1363737404' post='1303453001'] nenu incremental stg level lo chestunna ..i mean staging tables loki delta records load chestunnna ...appudu naaku oka main source(sql server idi after data..will be changing) and oracle (idi reference dtaa ....target idi deentho lookup chestunna so before dtaa idi) so naaku only stg table okkatey vundi upsert cheyytaniki ..ippudu inko op link paristhithi enti? [/quote] change capture stage vaadutunanraa mee vaallu inni rojulu ... ???
pandemkodi Posted March 21, 2013 Report Posted March 21, 2013 [quote name='dalapathi' timestamp='1363798914' post='1303456859'] change capture stage vaadutunanraa mee vaallu inni rojulu ... ??? [/quote] no mama nenu project change ayyanu just 3 weeks indi deenloki vachi
pandemkodi Posted March 21, 2013 Report Posted March 21, 2013 i have one more question .. nenu change capture stage use chestunna ..every time source data antha extract chyyakunda ela filte cheyyali...i mena every hour job run avvudhi so first run lo last hour data(12am-1am data) vastadi..next run lo source nunchi mottam antey 12-2am data mottam raakunda only 1-2am data ravali ela cheyyochu source lo emi timestamps levu
Manthrii Posted March 21, 2013 Report Posted March 21, 2013 [quote name='pandemkodi' timestamp='1363883011' post='1303462974'] ltt [/quote] ma project lo use chesinavi unnai mama. sample jobs. nenu work cheyyaledhu. vere option lekapothe cheppu.. avi emaina help avuthai anukunte chudham.
pandemkodi Posted March 21, 2013 Report Posted March 21, 2013 [quote name='Manthrii' timestamp='1363883164' post='1303462995'] ma project lo use chesinavi unnai mama. sample jobs. nenu work cheyyaledhu. vere option lekapothe cheppu.. avi emaina help avuthai anukunte chudham. [/quote] konchem choodu mama...maa vaadu chava godutunnadu roju emina chesava ani
Recommended Posts