dilkush Posted July 9, 2012 Report Posted July 9, 2012 [quote name='pandemkodi' timestamp='1341866441' post='1302104220'] babulu vunnarsa idendo ee error artha ithaledu choodandi [b]Error occurred during data acquisition. All instances must proceed to call EndAcquisition function[/b] [b]TD [/b]connector error [/quote] No idea..........google chestey dorakatledaa.........dsxchange lo evaru disco cheyyaledaa
pandemkodi Posted July 9, 2012 Report Posted July 9, 2012 [quote name='Dalapati' timestamp='1341866670' post='1302104243'] No idea..........google chestey dorakatledaa.........dsxchange lo evaru disco cheyyaledaa [/quote] google chesina dorakaledu Question vundi gaani ans ledu
qwerty1204 Posted July 18, 2012 Author Report Posted July 18, 2012 How to run a unix command in DataStage parallel job...
pandemkodi Posted July 18, 2012 Report Posted July 18, 2012 what do you mean you can use it in before after subroutine goto job properties and then in general tab u can see before job subroutine in that select EXecSH option(in before or afer based on u r req) give the commands
dilkush Posted July 18, 2012 Report Posted July 18, 2012 [quote name='pandemkodi' timestamp='1342631296' post='1302155478'] what do you mean you can use it in before after subroutine goto job properties and then in general tab u can see before job subroutine in that select EXecSH option(in before or afer based on u r req) give the commands [/quote] Agreed
qwerty1204 Posted July 18, 2012 Author Report Posted July 18, 2012 [quote name='pandemkodi' timestamp='1342631296' post='1302155478'] what do you mean you can use it in before after subroutine goto job properties and then in general tab u can see before job subroutine in that select EXecSH option(in before or afer based on u r req) give the commands [/quote] thanx baa wht if I need to run in between the stages..suppose with ia job..after executing some stages say..oka look-up ayna taryvatha..vachee data medha aa unix command ni run cheyali antee elaa
qwerty1204 Posted July 18, 2012 Author Report Posted July 18, 2012 [quote name='pandemkodi' timestamp='1342631296' post='1302155478'] what do you mean you can use it in before after subroutine goto job properties and then in general tab u can see before job subroutine in that select EXecSH option(in before or afer based on u r req) give the commands [/quote] and also what if I have 10 unix commands to execute and I have kept them in .sh file...then how to run that file over there?
pandemkodi Posted July 18, 2012 Report Posted July 18, 2012 [quote name='arey ooo samba' timestamp='1342631866' post='1302155547'] thanx baa wht if I need to run in between the stages..suppose with ia job..after executing some stages say..oka look-up ayna taryvatha..vachee data medha aa unix command ni run cheyali antee elaa [/quote] appudu nuvvu job ni break cheyyalanukunta ila job madyalo cheyyalem mari naaku telisinantha varaku ....dala emantado amri
dilkush Posted July 18, 2012 Report Posted July 18, 2012 [quote name='arey ooo samba' timestamp='1342631981' post='1302155559'] and also what if I have 10 unix commands to execute and I have kept them in .sh file...then how to run that file over there? [/quote] aah job ni akkadiki aapesi.......inko part ni inko job gaa build cheyyochu kadaa........aah rendu parallel jobs ni sequencer lo petti....madhyalo execute command ivvochu anukuntaa.......kaanie konchem peddagaa avvuddemo....... Seq. file lo ivvochu antaa......idhi try cheyyi [url="http://www.dstagebox.com/2011/05/running-unix-commands-in-datastage/"]http://www.dstagebox.com/2011/05/running-unix-commands-in-datastage/[/url]
qwerty1204 Posted July 18, 2012 Author Report Posted July 18, 2012 [quote name='Dalapati' timestamp='1342632516' post='1302155614'] aah job ni akkadiki aapesi.......inko part ni inko job gaa build cheyyochu kadaa........aah rendu parallel jobs ni sequencer lo petti....madhyalo execute command ivvochu anukuntaa.......kaanie konchem peddagaa avvuddemo....... Seq. file lo ivvochu antaa......idhi try cheyyi [url="http://www.dstagebox.com/2011/05/running-unix-commands-in-datastage/"]http://www.dstagebox...s-in-datastage/[/url] [/quote] yaa adhii oka solution baa...ee madhya konni interviews attend avthunna..mana desi gallu..ilanti chetha questions askng
pandemkodi Posted July 18, 2012 Report Posted July 18, 2012 [quote name='arey ooo samba' timestamp='1342632856' post='1302155657'] yaa adhii oka solution baa...ee madhya konni interviews attend avthunna..mana desi gallu..ilanti chetha questions askng [/quote] desi gallu interview chestey attend cheyyaku baa lite sodi gaalu kavalani aadukuntaru
dilkush Posted July 18, 2012 Report Posted July 18, 2012 [quote name='arey ooo samba' timestamp='1342632856' post='1302155657'] yaa adhii oka solution baa...ee madhya konni interviews attend avthunna..mana desi gallu..ilanti chetha questions askng [/quote] manolla sangathi telissindey kadaa......vaadi requirement endho....aah work veedu chestaadoo ledoo ani chuudaru....first veedu fake aah real ani chuustaaru........real ayitey veediki entha matter vundaa ani paniki raanivi anie adugutaaru.....
qwerty1204 Posted July 23, 2012 Author Report Posted July 23, 2012 edhi evarikyna idea unda baa I have some data having duplicates..suppose my data is having two column (NAME and DATE) now I have remove duplicates for the column "NAME" but it should be based on the recent date(i.e for example there are two rows with name as RAM and date as 10/5/2010 and another rows with name as RAM and date as 12/5/2010 I need to fetch the second row out of those two...
dilkush Posted July 24, 2012 Report Posted July 24, 2012 [b]@ Sambaa[/b] First oka sort stage pettu......first key lo 'Name' ivvu.... sort order ascending pettu...... next key........'Date' ivvu......sort order Descending ani pettu........ kinda options lo allow duplicates 'False' ani pettu........stable sort true ani ivvu........ Input tab lo partitioning type 'Hash' ani ichi.........key 'Name' ani ivvu....... Idhi work avutadhi anukuntaa......... lekapotey..........itlaa try cheyyi....... Paina sort stage lo allow duplicates 'true' ani maarvu.......next inko remove duplicate stage pettu........keys that define duplicates lo 'Name' ivvu.....duplicate to retaina antye 'First' ani ivvu.....input lo partitioning 'Same' ani ivvu............ naaku telsii incase first dhi work out kaakapotey second dhi ayinaa kaavaali...........try chesi chuudu
qwerty1204 Posted July 25, 2012 Author Report Posted July 25, 2012 [quote name='Dalapati' timestamp='1343135079' post='1302191144'] [b]@ Sambaa[/b] First oka sort stage pettu......first key lo 'Name' ivvu.... sort order ascending pettu...... next key........'Date' ivvu......sort order Descending ani pettu........ kinda options lo allow duplicates 'False' ani pettu........stable sort true ani ivvu........ Input tab lo partitioning type 'Hash' ani ichi.........key 'Name' ani ivvu....... Idhi work avutadhi anukuntaa......... lekapotey..........itlaa try cheyyi....... Paina sort stage lo allow duplicates 'true' ani maarvu.......next inko remove duplicate stage pettu........keys that define duplicates lo 'Name' ivvu.....duplicate to retaina antye 'First' ani ivvu.....input lo partitioning 'Same' ani ivvu............ naaku telsii incase first dhi work out kaakapotey second dhi ayinaa kaavaali...........try chesi chuudu [/quote] nice baa...but how to retain those duplicate rows?
Recommended Posts