pandemkodi Posted March 27, 2013 Report Posted March 27, 2013 [quote name='dalapathi' timestamp='1364396037' post='1303495023'] adhi naaku sarigga telvadu ... etlaa work avvuddho ... anni files ki ade tmeplate kaabatti just edit chestunna [/quote] ok nenu ila cheddamanukuntunan bayya job run iyyaka last_process_dttm ni oka table loki teeskuni ....daanni use chesi sourc elo filter cheddamanukuntunna but ikkada inko issue vundi ...create cheina table is in oracle and source in sql server so deni meeda join cheyyalo teleta and also deletes ela capture cheyyalo kuda tleetla..any ideas
Silver_mani Posted March 27, 2013 Report Posted March 27, 2013 [quote name='pandemkodi' timestamp='1364397880' post='1303495302'] ok nenu ila cheddamanukuntunan bayya job run iyyaka last_process_dttm ni oka table loki teeskuni ....daanni use chesi sourc elo filter cheddamanukuntunna but ikkada inko issue vundi ...create cheina table is in oracle and source in sql server so deni meeda join cheyyalo teleta and also deletes ela capture cheyyalo kuda tleetla..any ideas [/quote] CDC stage ela vadalo example vuntadi chudu mama
Manthrii Posted March 27, 2013 Report Posted March 27, 2013 [quote name='pandemkodi' timestamp='1364397880' post='1303495302'] ok nenu ila cheddamanukuntunan bayya job run iyyaka last_process_dttm ni oka table loki teeskuni ....daanni use chesi sourc elo filter cheddamanukuntunna but ikkada inko issue vundi ...create cheina table is in oracle and source in sql server so deni meeda join cheyyalo teleta and also deletes ela capture cheyyalo kuda tleetla..any ideas [/quote] CDC insert update job pampincha chudu
Silver_mani Posted March 27, 2013 Report Posted March 27, 2013 iikkada rayadam kashtam mama....naaku phn chey ... explain chesta
pandemkodi Posted March 27, 2013 Report Posted March 27, 2013 [quote name='Silver_mani' timestamp='1364406892' post='1303496235'] iikkada rayadam kashtam mama....naaku phn chey ... explain chesta [/quote] number pm pls ty
dalapathi Posted March 27, 2013 Report Posted March 27, 2013 [quote name='pandemkodi' timestamp='1364397880' post='1303495302'] ok nenu ila cheddamanukuntunan bayya job run iyyaka last_process_dttm ni oka table loki teeskuni ....daanni use chesi sourc elo filter cheddamanukuntunna but ikkada inko issue vundi ...create cheina table is in oracle and source in sql server so deni meeda join cheyyalo teleta and also deletes ela capture cheyyalo kuda tleetla..any ideas [/quote] CDC stage vaadu easy gaa ayipotadhi andhulo stage lo link ordering ani vuntadhi ... akkda primary ki emo source ivvu ... secondary emo ... nuvvu edhi ayite target lo fill cheddma anukuntunnaavoo adhey ivvu ... ante source ni ee target table tho compare chestunnattu properties tab lo edho oka column key laagaa ivvu ... aah key kottahdi ayite insert ani chebutadhi ... options lo change mode lo explicit keys all values ani iste ... migitaa aey column change ayian update ani istadhi ... annie same vunte copy aah stage output lo change code values istadhi ... 0,1,2,3 ... 0 ante copy ani, 1 ante insert ani 2 ante edho vuntadhi ... delete kaavochu 3 ante edit ani anukuntaa itlaa next transformer lo aah codes ni abtti eneku edhi akavalante adhi chesukovachu
Silver_mani Posted March 27, 2013 Report Posted March 27, 2013 [quote name='dalapathi' timestamp='1364409677' post='1303496570'] CDC stage vaadu easy gaa ayipotadhi andhulo stage lo link ordering ani vuntadhi ... akkda primary ki emo source ivvu ... secondary emo ... nuvvu edhi ayite target lo fill cheddma anukuntunnaavoo adhey ivvu ... ante source ni ee target table tho compare chestunnattu properties tab lo edho oka column key laagaa ivvu ... aah key kottahdi ayite insert ani chebutadhi ... options lo change mode lo explicit keys all values ani iste ... migitaa aey column change ayian update ani istadhi ... annie same vunte copy aah stage output lo change code values istadhi ... 0,1,2,3 ... 0 ante copy ani, 1 ante insert ani 2 ante edho vuntadhi ... delete kaavochu 3 ante edit ani anukuntaa itlaa next transformer lo aah codes ni abtti eneku edhi akavalante adhi chesukovachu [/quote] baaga raasav mayya
pandemkodi Posted March 27, 2013 Report Posted March 27, 2013 [quote name='dalapathi' timestamp='1364409677' post='1303496570'] CDC stage vaadu easy gaa ayipotadhi andhulo stage lo link ordering ani vuntadhi ... akkda primary ki emo source ivvu ... secondary emo ... nuvvu edhi ayite target lo fill cheddma anukuntunnaavoo adhey ivvu ... ante source ni ee target table tho compare chestunnattu properties tab lo edho oka column key laagaa ivvu ... aah key kottahdi ayite insert ani chebutadhi ... options lo change mode lo explicit keys all values ani iste ... migitaa aey column change ayian update ani istadhi ... annie same vunte copy aah stage output lo change code values istadhi ... 0,1,2,3 ... 0 ante copy ani, 1 ante insert ani 2 ante edho vuntadhi ... delete kaavochu 3 ante edit ani anukuntaa itlaa next transformer lo aah codes ni abtti eneku edhi akavalante adhi chesukovachu [/quote] bayya neeku nenu cheppindi artham kaanattundi nenu idnatha chesanu but still every time source table fulltable scan chestondi neeku example chepta aagu source lo last_update_dttm aney field vundi target lo kuda same field but different nam last_procedd_dttm first intial load ivvala chesam 100 records vachayi 3/27/2013 target lo avi velli load avutai rapu malli load chestunnam so repu 10 recods vastunnai appudu source table mottam scan cheyyakunda only 10 records either i/u/d codes tho ravali ani naa maeaning daaniki source table lo where last_update_dttm>max(last_processed_dttm) ani pettali antey target lo ni maximum last_processed_dttm kantey ekkuva vunna date values ee manaku source table lo nunchi bayataki ravali ............shortcut lo latest records
pandemkodi Posted March 27, 2013 Report Posted March 27, 2013 ok naaku oka table lo date filed vundi like table name date_1:3/27/2013 12:00:323 inko table lo nuber of dates vunnai like date_multiple : 3/27/2013 12:00:323 3/26/2013 12;00:234 3/28/2013 12:00:000 3/29/2013 12:00:000 vunnai ippudu naaku o/p vachi only ivi ravali 3/28/2013 12:00:000 3/29/2013 12:00:000 one table in sql server another in oracle..date key column kaadu ...inka renditlo common columns levu except date how can i acheive this ?
dalapathi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='pandemkodi' timestamp='1364424862' post='1303498357'] ok naaku oka table lo date filed vundi like table name date_1:3/27/2013 12:00:323 inko table lo nuber of dates vunnai like date_multiple : 3/27/2013 12:00:323 3/26/2013 12;00:234 3/28/2013 12:00:000 3/29/2013 12:00:000 vunnai ippudu naaku o/p vachi only ivi ravali 3/28/2013 12:00:000 3/29/2013 12:00:000 one table in sql server another in oracle..date key column kaadu ...inka renditlo common columns levu except date how can i acheive this ? [/quote] sqlserver through aah oracle dhi kuudaa run cheyyochu kadaa ... lync server ooh edho vuntadhi ... adhi setup cheste only sql server query lo nunde aah oracle database lo vunna daanini kuudaa call cheyyochu ... etlaa setup chestaaroo daanini exactly emantaaroo telvadu ... maa daantlo aey database ayian sare ... maa staging database sql server daanithone vere source systems, oracle, cache databe lu itlaa annitiki deeni nunde raasi ... daane ODBC connector stage lo vaadutaam naaku telsi deeni gurinchi oka speerate thread post cheste better emo SQL server vaallaki easy gaa tlesi vuntadhi
qwerty1204 Posted March 28, 2013 Author Report Posted March 28, 2013 dala and pandemkodi baa...iddari oka oka video shoot tesi explain cheyandi ..asalu question enti...answer enti ani
dalapathi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='arey ooo samba' timestamp='1364436815' post='1303499276'] dala and pandemkodi baa...iddari oka oka video shoot tesi explain cheyandi ..asalu question enti...answer enti ani [/quote] antha matter chuusi [img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img] ayyindaa
qwerty1204 Posted March 28, 2013 Author Report Posted March 28, 2013 [quote name='dalapathi' timestamp='1364437022' post='1303499293'] antha matter chuusi [img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img] ayyindaa [/quote] asalu ee CDC stage ante first nunchi enthe baa [img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img]...concept wise vinadaniki ardam chesukovadaniki bagane untadi kani..stages ni configure cheyali ante...[img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img]
dalapathi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='arey ooo samba' timestamp='1364439360' post='1303499565'] asalu ee CDC stage ante first nunchi enthe baa [img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img]...concept wise vinadaniki ardam chesukovadaniki bagane untadi kani..stages ni configure cheyali ante...[img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img] [/quote] akkada issue CDC stage kaadhu[img]http://lh6.ggpht.com/-LkjiY7VR-0w/UUeyLvnASwI/AAAAAAAAKpM/uIOktpTCzJM/s150/Brahmi-25.gif[/img]
pandemkodi Posted March 28, 2013 Report Posted March 28, 2013 [quote name='dalapathi' timestamp='1364435411' post='1303499145'] sqlserver through aah oracle dhi kuudaa run cheyyochu kadaa ... lync server ooh edho vuntadhi ... adhi setup cheste only sql server query lo nunde aah oracle database lo vunna daanini kuudaa call cheyyochu ... etlaa setup chestaaroo daanini exactly emantaaroo telvadu ... maa daantlo aey database ayian sare ... maa staging database sql server daanithone vere source systems, oracle, cache databe lu itlaa annitiki deeni nunde raasi ... daane ODBC connector stage lo vaadutaam naaku telsi deeni gurinchi oka speerate thread post cheste better emo SQL server vaallaki easy gaa tlesi vuntadhi [/quote] Ippudu adendo Chestey Sql lo ney oracle access cheyyochantav anthey na mama ...nenu already odbc stage ee vaadutunna source
Recommended Posts