@@@@calling All Datastage Developers@@@@

[kalyann]

[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]

[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]

[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]

[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]

[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]

[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]

[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]

[img]http://i.imgur.com/Ek0TO.gif[/img]

[pandemkodi]

naa kedina job choosi pettandi vayy

[mrudhula99]

[quote name='pandemkodi' timestamp='1358594750' post='1303136862']
naa kedina job choosi pettandi vayy
[/quote]


india nundi vachesavaaa [size=4] [/size][size=4] [/size]

[pandemkodi]

[quote name='mrudhula99' timestamp='1358602983' post='1303136989']


india nundi vachesavaaa [size=4] [/size]
[/quote]
2 days lo

[Mrlavangam]

[quote name='pandemkodi' timestamp='1358753525' post='1303144387']
2 days lo
[/quote]
[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[qwerty1204]

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]

[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]

[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]