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

[mrudhula99]

[quote name='pandemkodi' timestamp='1345762125' post='1302369181']
edokati cheyy
[/quote]
[img]http://i37.tinypic.com/2ykxr1e.gif[/img] nuvvu PLSQL script elaa raastharooo chuseee post chesthavaaa??

[pandemkodi]

[quote name='mrudhula99' timestamp='1345762272' post='1302369193']
[img]http://i37.tinypic.com/2ykxr1e.gif[/img] nuvvu PLSQL script elaa raastharooo chuseee post chesthavaaa??
[/quote]
stored proc raasko

[mrudhula99]

[quote name='pandemkodi' timestamp='1345762458' post='1302369210']
stored proc raasko
[/quote]
mustang store proc rasthadanta....


do you know the format of that??

lekapothee already raasena stored proc chustha...

will get some idea it seems...

assalu stored proc and PLSQL use cehsee jobs nenu design cheyyalsena avasaram raaledhu naku....

suddden ga avasthee chala problem ayyedhee

[pandemkodi]

[quote name='mrudhula99' timestamp='1345762607' post='1302369227']
mustang store proc rasthadanta....


do you know the format of that??

lekapothee already raasena stored proc chustha...

will get some idea it seems...

assalu stored proc and PLSQL use cehsee jobs nenu design cheyyalsena avasaram raaledhu naku....

suddden ga avasthee chala problem ayyedhee
[/quote]
memu stored proc raasi daanni jopb lo call chestam
edo chinna chinnavi rayochu but cursors use cheyytam raadu
ina cursors use chestey prformence taggipoddi avi row by row process cheystai so prod lo it takes hell lot of time .....
stored proc's format endi naa pindakudu

[mrudhula99]

[quote name='pandemkodi' timestamp='1345762666' post='1302369235']
memu stored proc raasi daanni jopb lo call chestam
[/quote]
ooh avunaaa...

[mrudhula99]

[quote name='pandemkodi' timestamp='1345762666' post='1302369235']
memu stored proc raasi daanni jopb lo call chestam
edo chinna chinnavi rayochu but cursors use cheyytam raadu
ina cursors use chestey prformence taggipoddi avi row by row process cheystai so prod lo it takes hell lot of time .....
stored proc's format endi naa pindakudu
[/quote]
lolz...

assalu ye stage use chestharu stored proc call cheyyatanki....
adhe kuda same sql laga nee untundhaa??? manaki ardham ayyedhaa???

[qwerty1204]

ee interview questions ki answer enti baa

you job is running in multiple instances...and the task is to load 10 source tables (SRC1, SRC2 and so on are the source table names) to 10 target tables (TRGT1, TRGT2 and so on are the target table names) how can we do it using a single job?

[mrudhula99]

[quote name='arey ooo samba' timestamp='1345764177' post='1302369353']
ee interview questions ki answer enti baa

you job is running in multiple instances...and the task is to load 10 source tables (SRC1, SRC2 and so on are the source table names) to 10 target tables (TRGT1, TRGT2 and so on are the target table names) how can we do it using a single job?
[/quote]
job sequence use chesee.... 10 job activities add chesthee... multiple instance loo run ayyee same time loo anne tables load ayyepothai ani

[qwerty1204]

[quote name='mrudhula99' timestamp='1345764302' post='1302369361']
job sequence use chesee.... 10 job activities add chesthee... multiple instance loo run ayyee same time loo anne tables load ayyepothai ani
[/quote]

hmm..eee approach valid oo kadu oo teliyadu...vadini nee answer adugudhamu anukunna

I think its some thng to do with invocationID..but not sure..how we to that

[mrudhula99]

[quote name='arey ooo samba' timestamp='1345764513' post='1302369375']

hmm..eee approach valid oo kadu oo teliyadu...vadini nee answer adugudhamu anukunna

I think its some thng to do with invocationID..but not sure..how we to that
[/quote]
invocation theleidha???? lolz...

emundadhu... job properties ki velli akkada option click chesthee sarepothundhe....

[pandemkodi]

[quote name='mrudhula99' timestamp='1345764302' post='1302369361']
job sequence use chesee.... 10 job activities add chesthee... multiple instance loo run ayyee same time loo anne tables load ayyepothai ani
[/quote]
nope single job antey seq lo activities add cheyyamani kaadu kada

[pandemkodi]

[quote name='mrudhula99' timestamp='1345764727' post='1302369387']
invocation theleidha???? lolz...

emundadhu... job properties ki velli akkada option click chesthee sarepothundhe....
[/quote]
nadaru nee antha goppavallundaru kada

[Jail Breaker]

[quote name='mrudhula99' timestamp='1345764727' post='1302369387']
invocation theleidha???? lolz...

emundadhu... job properties ki velli akkada option click chesthee sarepothundhe....
[/quote]

dont make fun of others... [img]http://lh5.ggpht.com/-g6s94Cubhp4/TwKMes3AxhI/AAAAAAAAFug/GwFuNEOm6WU/s150/Sam-5.gif[/img]

ee thread ni baga utilize cheskuntunnav ga.

[mrudhula99]

[quote name='Jail Breaker' timestamp='1345765259' post='1302369416']

dont make fun of others... [img]http://lh5.ggpht.com/-g6s94Cubhp4/TwKMes3AxhI/AAAAAAAAFug/GwFuNEOm6WU/s150/Sam-5.gif[/img]

ee thread ni baga utilize cheskuntunnav ga.
[/quote]
i'm really soo ..

i didn't mean that way... naku kuda adhem raadhuuu..

thelsukunteee enthe naa anpinchedhee... soo alaa react ayyanuu

[mrudhula99]

[quote name='pandemkodi' timestamp='1345765035' post='1302369403']
nadaru nee antha goppavallundaru kada
[/quote]
dhantlo antha pedha ga nerchukunedhee em ledhuuuu..

easy ga nee untundhe.... just click cheyyali anthee oka box..

really .... am not making fun of any...