kalyann Posted January 17, 2013 Report Posted January 17, 2013 [quote name='lolliman' timestamp='1358444511' post='1303124136'] cheyyachanukuntaa... maaku BODS lo aa option vundi mari... so indulo kooda vuntadi anukuntaaa [/quote] ok bro thanks
qwerty1204 Posted January 17, 2013 Author Report Posted January 17, 2013 [quote name='Silver_mani' timestamp='1358442934' post='1303123884'] mee dantlo inka ft positions vunnaya baa ??? [/quote] nenu aa job join avvaledu ga baa same proj lo nee continue avthunna
kalyann Posted January 17, 2013 Report Posted January 17, 2013 [quote name='arey ooo samba' timestamp='1358447018' post='1303124596'] nenu aa job join avvaledu ga baa same proj lo nee continue avthunna [/quote] bro, nenu oka question adiganu paina, teliste cheppava?
qwerty1204 Posted January 17, 2013 Author Report Posted January 17, 2013 [quote name='kalyann' timestamp='1358443161' post='1303123920'] hey oka question ds lo odbc stage lo commit size will be 2000 default, can we change it to 500? [/quote] yes u can baa... basic ga two options untayi baa okati transaction record size inkokati session array size first dhi related to commit level...like if you mention it as 500 then..after every 500 rows the DB will commit those transactions second dhi related to no.of records that are loaded into buffer for proccessing..
kalyann Posted January 17, 2013 Report Posted January 17, 2013 [quote name='arey ooo samba' timestamp='1358447179' post='1303124632'] yes u can baa... basic ga two options untayi baa okati transaction record size inkokati session array size first dhi related to commit level...like if you mention it as 500 then..after every 500 rows the DB will commit those transactions second dhi related to no.of records that are loaded into buffer for proccessing.. [/quote] thanks baa for ur quick reply..no of records lo kuda 500 ki set cheyocha aite?
qwerty1204 Posted January 17, 2013 Author Report Posted January 17, 2013 [quote name='kalyann' timestamp='1358447371' post='1303124676'] thanks baa for ur quick reply..no of records lo kuda 500 ki set cheyocha aite? [/quote] depends on your REQ baa...if you want to commit 500 records at a time..then go with it
kalyann Posted January 17, 2013 Report Posted January 17, 2013 [quote name='arey ooo samba' timestamp='1358460620' post='1303126845'] depends on your REQ baa...if you want to commit 500 records at a time..then go with it [/quote] ok bhayya thanks for ur responce
mrudhula99 Posted January 18, 2013 Report Posted January 18, 2013 [img]http://i.imgur.com/Ek0TO.gif[/img]
pandemkodi Posted January 19, 2013 Report Posted January 19, 2013 naa kedina job choosi pettandi vayy
mrudhula99 Posted January 19, 2013 Report Posted January 19, 2013 [quote name='pandemkodi' timestamp='1358594750' post='1303136862'] naa kedina job choosi pettandi vayy [/quote] india nundi vachesavaaa [size=4] [/size][size=4] [/size]
pandemkodi Posted January 21, 2013 Report Posted January 21, 2013 [quote name='mrudhula99' timestamp='1358602983' post='1303136989'] india nundi vachesavaaa [size=4] [/size] [/quote] 2 days lo
Mrlavangam Posted January 21, 2013 Report Posted January 21, 2013 [quote name='pandemkodi' timestamp='1358753525' post='1303144387'] 2 days lo [/quote] [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
qwerty1204 Posted January 21, 2013 Author Report Posted January 21, 2013 oka sequence lo 5 jobs unnayi.."Checkpointing is enabled in the sequence" sequence is aborted....the reason is job3 is completed with warnings (it ran successfully, but completed with some warnings).. our condition is ...every job has to be completed with out any warnings...since job3 has some warnings in it... the sequence get aborted eppudu manamu sequence malli restart cehsthe..frm which job does it resumes its execution..is it job3 or job4? another question was sequence job properties lo inko opton untadi "Automatically handle activities that fail" ani what is the use of it?
mrudhula99 Posted January 21, 2013 Report Posted January 21, 2013 [quote name='arey ooo samba' timestamp='1358805493' post='1303147763'] oka sequence lo 5 jobs unnayi.."Checkpointing is enabled in the sequence" sequence is aborted....the reason is job3 is completed with warnings (it ran successfully, but completed with some warnings).. our condition is ...every job has to be completed with out any warnings...since job3 has some warnings in it... the sequence get aborted eppudu manamu sequence malli restart cehsthe..frm which job does it resumes its execution..is it job3 or job4? another question was sequence job properties lo inko opton untadi "Automatically handle activities that fail" ani what is the use of it? [/quote] compile cheyyeakundaa run cheyyee.. apudu job3 nundi start avuthundhiii..... compile chesthee malli first nundii start avuthundhii
qwerty1204 Posted January 22, 2013 Author Report Posted January 22, 2013 [quote name='mrudhula99' timestamp='1358812107' post='1303148407'] compile cheyyeakundaa run cheyyee.. apudu job3 nundi start avuthundhiii..... compile chesthee malli first nundii start avuthundhii [/quote] hmm.. even though the job3 finish ayna sare...it will again start frm job3..since the cjeck point only captures until tht point..anteenaa in tht case...if in an example case job3 loads the data into a table..and we restart the sequence..then it will again try to insert the same records into the table..then may be proper handling has to be taken care of sarle..how abt the nxt one [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]another question was sequence job properties lo inko opton untadi "Automatically handle activities that fail" ani what is the use of it?[/background][/size][/font][/color]
Recommended Posts