Chakram12 Posted August 24, 2012 Report Share Posted August 24, 2012 [url="http://www.andhrafriends.com/topic/329309-calling-mrudhula/page__pid__1302369879#entry1302369879"]http://www.andhrafriends.com/topic/329309-calling-mrudhula/page__pid__1302369879#entry1302369879[/url] Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 24, 2012 Report Share Posted August 24, 2012 ??? Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 [quote name='mrudhula99' timestamp='1345771052' post='1302369905'] aggregator lo marks add cheyyee.. next sort stage use cheyyee... sort stage loo rank 1 2 3.. RCP on cheskoni generate cheyyee.... elaa cehsthe ravochu.. nenu repu create cehskoni... try chestha... naku thelsee elaagee chesthaaru.... [/quote] how abt the names...names should be in align with the rank Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 24, 2012 Report Share Posted August 24, 2012 [quote name='arey ooo samba' timestamp='1345771702' post='1302369982'] how abt the names...names should be in align with the rank [/quote] sort stage loo oka option untundhe... there you can get an extra surrogate column or rank column... for sure ggaaa undhe akkada option Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 [quote name='mrudhula99' timestamp='1345772130' post='1302370024'] sort stage loo oka option untundhe... there you can get an extra surrogate column or rank column... for sure ggaaa undhe akkada option [/quote] repuu poyii chustaa Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 24, 2012 Report Share Posted August 24, 2012 [quote name='arey ooo samba' timestamp='1345772464' post='1302370074'] repuu poyii chustaa [/quote] yeah chudu,,, I too will look Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 [quote name='arey ooo samba' timestamp='1345770805' post='1302369875'] oh kk...ee scenarios loo use chestaru..apart frm the one I have asked and one more doubt input data ila undi NAME MARKS1 MARKS2 MARKS3 ABC 70 80 90 PQR 40 50 50 MNC 90 70 60 o/p data ila ravali ante elaa RANK NAME TOTAL_MARKS 1 ABC 240 2 MNC 220 3 PQR 140 [/quote] asalu aa 3 cols data ni single column loo ki add cheyali antee elaa group by ani ee naa..if soo how does the query looks like Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 24, 2012 Report Share Posted August 24, 2012 [quote name='arey ooo samba' timestamp='1345772842' post='1302370122'] asalu aa 3 cols data ni single column loo ki add cheyali antee elaa group by ani ee naa..if soo how does the query looks like [/quote] akkarledhu groupby.. datastage lo transformer lo cheyyochu gaa add chesee okka coloumn loki pampinchu..... col1+col2+col3 ---> col Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 parallel job ki allow multiple instance option chk chesanu...and now when i am in seqence job and created a job activity and open up is properties aa InvocatioID place loo defualt ga target database table name mention chesi undi (in my parallel job) now..if I want to run my job 5 times what is thjat I have to do... Link to comment Share on other sites More sharing options...
Gachibowli_Diwakar Posted August 24, 2012 Report Share Posted August 24, 2012 [img]http://i45.tinypic.com/j9st51.jpg[/img] DB lo kuda entha kashtapaduthunnaaru Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 [quote name='Silence..Please' timestamp='1345827174' post='1302373803'] [img]http://i45.tinypic.com/j9st51.jpg[/img] DB lo kuda entha kashtapaduthunnaaru [/quote] DS medha fremaa alantidi baa[img]http://i45.tinypic.com/j9st51.jpg[/img] Link to comment Share on other sites More sharing options...
Gachibowli_Diwakar Posted August 24, 2012 Report Share Posted August 24, 2012 [quote name='arey ooo samba' timestamp='1345827296' post='1302373815'] DS medha fremaa alantidi baa[img]http://i45.tinypic.com/j9st51.jpg[/img] [/quote] prema na .. lekapothe potta kuuti kosam aah [img]http://i47.tinypic.com/v81xyd.jpg[/img] Link to comment Share on other sites More sharing options...
mrudhula99 Posted August 24, 2012 Report Share Posted August 24, 2012 [quote name='arey ooo samba' timestamp='1345827141' post='1302373800'] parallel job ki allow multiple instance option chk chesanu...and now when i am in seqence job and created a job activity and open up is properties aa InvocatioID place loo defualt ga target database table name mention chesi undi (in my parallel job) now..if I want to run my job 5 times what is thjat I have to do... [/quote] invocation Id dhaggaraa DB nme evvakudahduuu Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 [quote name='Silence..Please' timestamp='1345827407' post='1302373825'] prema na .. lekapothe potta kuuti kosam aah [img]http://i47.tinypic.com/v81xyd.jpg[/img] [/quote] maa mama podduturu MLA[img]http://i47.tinypic.com/v81xyd.jpg[/img] Link to comment Share on other sites More sharing options...
qwerty1204 Posted August 24, 2012 Author Report Share Posted August 24, 2012 [quote name='mrudhula99' timestamp='1345827524' post='1302373832'] invocation Id dhaggaraa DB nme evvakudahduuu [/quote] nenu ivvaledu default ga adhii populate ayyi undi ani cheptunna Link to comment Share on other sites More sharing options...
Recommended Posts