mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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?? Link to comment Share on other sites More sharing options...
pandemkodi Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
pandemkodi Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [quote name='pandemkodi' timestamp='1345762666' post='1302369235'] memu stored proc raasi daanni jopb lo call chestam [/quote] ooh avunaaa... Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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??? Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 23, 2012 Author Report Share Posted August 23, 2012 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? Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 23, 2012 Author Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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.... Link to comment Share on other sites More sharing options...
pandemkodi Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
pandemkodi Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
Jail Breaker Posted August 23, 2012 Report Share Posted August 23, 2012 [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. Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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 Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 23, 2012 Report Share Posted August 23, 2012 [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... Link to comment Share on other sites More sharing options...
Recommended Posts