dalapathi Posted March 5, 2013 Report Posted March 5, 2013 [quote name='pandemkodi' timestamp='1362521078' post='1303371024'] bayya memu incremental loading cheyyali from sql views so staging lo ddl's lo extar columns emi add cheyyali ani nannu adigadu maa modeler gaadu konchem cheppandi em add cheyyalo like timestamps ,last_update_time ilantivi [/quote] record created date, record modified date ... ediana row lo ediana update ayite record modified date change ayyetattu ... new record insert ayite record created date, modified date ame vuntaayi
pandemkodi Posted March 5, 2013 Report Posted March 5, 2013 [quote name='dalapathi' timestamp='1362521282' post='1303371043'] record created date, record modified date ... ediana row lo ediana update ayite record modified date change ayyetattu ... new record insert ayite record created date, modified date ame vuntaayi [/quote] nennu insert_dttm record insert ina timestamp last_modified_dttm last update ina timestamp last_processed_dttm last time record process ina timestamp last_actn_cd weather it is updated or inserted or deleted ivi ok na bro inka emina kavala
dalapathi Posted March 6, 2013 Report Posted March 6, 2013 [quote name='pandemkodi' timestamp='1362522196' post='1303371087'] nennu insert_dttm record insert ina timestamp last_modified_dttm last update ina timestamp last_processed_dttm last time record process ina timestamp last_actn_cd weather it is updated or inserted or deleted ivi ok na bro inka emina kavala [/quote] last processed date time endhuku ... ??? record process ayyindhi ante adhi insert ayite insert_dttm anooo leka update ayite modified_dttm anoo already vuntahdi kadaa antey ee processed date time edho oka daaniki equal vuntahdi kadaa ... edian scenario lo veru vude chance vundaa?
pandemkodi Posted March 6, 2013 Report Posted March 6, 2013 [quote name='dalapathi' timestamp='1362535445' post='1303371941'] last processed date time endhuku ... ??? record process ayyindhi ante adhi insert ayite insert_dttm anooo leka update ayite modified_dttm anoo already vuntahdi kadaa antey ee processed date time edho oka daaniki equal vuntahdi kadaa ... edian scenario lo veru vude chance vundaa? [/quote] Vundadhu mama Nuvvu annadi correctey
dalapathi Posted March 6, 2013 Report Posted March 6, 2013 [quote name='pandemkodi' timestamp='1362541147' post='1303372372'] Vundadhu mama Nuvvu annadi correctey [/quote] naaku telsi aah column avasarma ledu Incase emeru update cheisna prahti saari aah column paatha history store cheste tappa ... atla aayite primary key duplicates vutaayi ... naaku tlesi aah column avasarma ledu
pandemkodi Posted March 6, 2013 Report Posted March 6, 2013 [quote name='dalapathi' timestamp='1362549041' post='1303373005'] naaku telsi aah column avasarma ledu Incase emeru update cheisna prahti saari aah column paatha history store cheste tappa ... atla aayite primary key duplicates vutaayi ... naaku tlesi aah column avasarma ledu [/quote] naaku sql server lo 4 tables vunnai vaatini join chesi oracle lo oka table lo load cheyyali incrementally ela cheyyali design plz
pandemkodi Posted March 7, 2013 Report Posted March 7, 2013 orace sequnce use chesi evarina skey generate chesara .....ela cheyyali ..nenu incremental from sql server loading into oracle so elago cheppandi vayya
deals2buy Posted March 7, 2013 Report Posted March 7, 2013 [quote name='pandemkodi' timestamp='1362685815' post='1303381911'] orace sequnce use chesi evarina skey generate chesara .....ela cheyyali ..nenu incremental from sql server loading into oracle so elago cheppandi vayya [/quote] adi nee transformation lo ne untundi kadaa...when u write the create table
dalapathi Posted March 8, 2013 Report Posted March 8, 2013 [quote name='Alexander' timestamp='1362691698' post='1303382664'] calling mrudula naaku oka doubt undhi [/quote] Pakka DB lo busy
deals2buy Posted March 8, 2013 Report Posted March 8, 2013 [quote name='dalapathi' timestamp='1362724490' post='1303385198'] Pakka DB lo busy [/quote] koddiga rammanu bhayya...ikkada chala doubts unnayi maaku
mettastar Posted March 8, 2013 Report Posted March 8, 2013 [url="http://www.techonthenet.com/oracle/sequences.php"]http://www.techonthenet.com/oracle/sequences.php[/url] direct ga table meeda create avuthu untadi for every record u insert... SKEY column ki default aa seq use cheyii
dalapathi 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] yeah, chebutaa
deals2buy Posted March 8, 2013 Report Posted March 8, 2013 [quote name='dalapathi' timestamp='1362760106' post='1303387042'] yeah, chebutaa [/quote] Thanks...aa Jejamma mimmalni challaga chudu gaaka [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]
Recommended Posts