pandemkodi Posted December 18, 2012 Report Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355859580' post='1302974762'] file ki kuda sagam sagam lod cheyyadhaa?? incase job run avuthunnapudu suppose 1000 rows load ayyaka.. nenu job stop chesaa anukoo... appudu emavuthundhii? [/quote] i m not sure abt file but db tables commit cheyyavu
mrudhula99 Posted December 18, 2012 Report Posted December 18, 2012 [quote name='pandemkodi' timestamp='1355859746' post='1302974797'] i m not sure abt file but db tables commit cheyyavu [/quote]
qwerty1204 Posted December 18, 2012 Author Report Posted December 18, 2012 if just read online..in DB2 connector stage properties...we have two options Transaction size: It is the number of rows after which a COMMIT needs to be issued (defaulted to 2000) Array Size: It is the number of rows to be processed at the same time (defaulted to 2000) if we change Transaction size:0 and keep Array Size as 2000 itself then...we achieve either all or none case
qwerty1204 Posted December 18, 2012 Author Report Posted December 18, 2012 [quote name='pandemkodi' timestamp='1355859746' post='1302974797'] i m not sure abt file but db tables commit cheyyavu [/quote] TransactionSize: 2000 default kada bhayya.. suppose we are loading 4000 rows into a DB2 table after loading 2500 rows if we came across some data data..the jobd willa bort...then the first 2000 are loaded into DB2 table as the TransactionSize: is set to 2000 records.
mrudhula99 Posted December 18, 2012 Report Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355860043' post='1302974839'] if just read online..in DB2 connector stage properties...we have two options Transaction size: It is the number of rows after which a COMMIT needs to be issued (defaulted to 2000) Array Size: It is the number of rows to be processed at the same time (defaulted to 2000) if we change Transaction size:0 and keep Array Size as 2000 itself then...we achieve either all or none case [/quote]
lolliman Posted December 18, 2012 Report Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355860030' post='1302974835'] [/quote] mari neeku thelisindi cheppu
pandemkodi Posted December 18, 2012 Report Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355860188' post='1302974862'] [/quote]
pandemkodi Posted December 18, 2012 Report Posted December 18, 2012 [quote name='lolliman' timestamp='1355860248' post='1302974874'] mari neeku thelisindi cheppu [/quote]
qwerty1204 Posted December 18, 2012 Author Report Posted December 18, 2012 kani naa main doubt adhi kadu bhayyaa.. I have a case where I have two tables having parent child relationship between them I loaded the the parent table first with 10 records and then while loading child table..if the job aborts aftes..is there a way i can delete the records in parent table too.?? [b]Can I do all this in a single job? like giving two input links to a single DB2 stage[/b]
pandemkodi Posted December 18, 2012 Report Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355860043' post='1302974839'] if just read online..in DB2 connector stage properties...we have two options Transaction size: It is the number of rows after which a COMMIT needs to be issued (defaulted to 2000) Array Size: It is the number of rows to be processed at the same time (defaulted to 2000) if we change Transaction size:0 and keep Array Size as 2000 itself then...we achieve either all or none case [/quote] agreed
mrudhula99 Posted December 18, 2012 Report Posted December 18, 2012 [quote name='pandemkodi' timestamp='1355860279' post='1302974876'] [/quote] [quote name='lolliman' timestamp='1355860248' post='1302974874'] mari neeku thelisindi cheppu [/quote] maa office lo Datastage new version DS9 ki migrate chesthunnaranta.... ma lead chepparu... kani maa team lo unna 5 members akkarledhu 2 members ee kavalannaru... donno my project gonna extend or not.
mrudhula99 Posted December 18, 2012 Report Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355860602' post='1302974923'] kani naa main doubt adhi kadu bhayyaa.. I have a case where I have two tables having parent child relationship between them I loaded the the parent table first with 10 records and then while loading child table..if the job aborts aftes..is there a way i can delete the records in parent table too.?? [b]Can I do all this in a single job? like giving two input links to a single DB2 stage[/b] [/quote] naa idea entantee... oka job create cheyyee.. which will load the data to both the tables... sequencer theesko... akkada seq command raayi.. emani rasthav ante... in case no of records in child table is zero... then delete the parent related records in the parent table ani.. then run that seq.....
qwerty1204 Posted December 18, 2012 Author Report Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355861216' post='1302974998'] naa idea entantee... oka job create cheyyee.. which will load the data to both the tables... sequencer theesko... akkada seq command raayi.. emani rasthav ante... in case no of records in child table is zero... then delete the parent related records in the parent table ani.. then run that seq..... [/quote] gud idea...have to see...if its possible to include in the exsisitng design..
mrudhula99 Posted December 18, 2012 Report Posted December 18, 2012 [quote name='arey ooo samba' timestamp='1355865068' post='1302975491'] gud idea...have to see...if its possible to include in the exsisitng design.. [/quote] let me know.. if you can find better way than what I mentioned... Happy christmas..
dalapathi Posted December 18, 2012 Report Posted December 18, 2012 [quote name='mrudhula99' timestamp='1355865422' post='1302975528'] let me know.. if you can find better way than what I mentioned... [size=5][b]Happy christmas..[/b][/size] [/quote] Inka 1 week vundhi kadaa ... appudey thondarendhi[img]http://i41.tinypic.com/105rtit.gif[/img]
Recommended Posts