DSXchange

Hi ray, my input like this ename managerid raj,sasi,chum 1000 kumar,vin 1001 kotak,vatson,jem,pinky 1002 and i want output like this ename managerid raj 1000 sasi 1000 chum 1000 kumar 1001 vin 1001 kotak 1002 vatson 1002 jem 1002 pinky 1002 Thanks in Adavance vin...

Hi ray, Please see this one 1.configfile main_program: APT configuration file: C:/IBM/InformationServer/Server/Configurations/2node.apt { node "node1" { fastname "TOMEDW" pools "" resource disk "C:/IBM/InformationServer/Server/Datasets" {pools ""} re...

Hi ray,
I have changed execution mode for row generator .i am getting like this
It runs 6 processes on 1 node.
but in config file i set 2nodes.but it not showing
it runs some processes on 2node..
Thanks
Vin..

Hi Rajesh,
I cant getting what u saying..i didnt get which environmental variable for that. in job itself i have changed combinality mode as dont'combine.but i am getting like this
it runs 7 processers on 1 node.

Thanks
Vin..

Hi, In confiuration file i have set two nodes.resource disk for first one i given d:/datastage/datasets,for second resorce disk for second node i given E:/datastage/datasets. my job contains rowgenerator--->sort--->lookup(ref rowgeenrator)--->dataset after executing that job on 2node but it showing ...

Hi Chulett, i didnt mentioned clearly in previous message. CM PM CL PL OP AMT A A 1 1 + B A 2 1 + 10 D C 4 3 + 5 E A 2 1 - C B 3 2 + 10 F E 3 2 + 5 G F 4 3 + 10 H G 5 4 + 5 WHERE CM=CURRENT MEASURE PM=PARENT MEASURE CL=CURRENT LEVEL PL=PARENT LEVEL OP=OPERATION BETWEN THEM AMT=AMOUNT HERE GROUP BY C...

Hi chulett, i said that one sample data.in source data i wil get so many levels. according to that one i have to do operation.for example CM PM CL PL OP AMOUNT A A 1 1 + B A 2 1 + 10 D C 4 3 - 5 C B 3 2 + 10 H G 5 4 + 5 G F 4 3 + 5 F

Hi ArndW,
Thanks for your reply...

Thanks and regards
vin.....

Hi Pathipati,
Thanks for ur reply..I have mentioned in the above how i tried.if i have single column its working.if more than 1 column in input its not working..any other idea to solve that one...

Thanks in adavance
vin...

Hi ray,
Just if i changed in config file it wil wil convert to 2node or i have to do any thing in hardware side.how we wil create logical processing nodes in single CPU...

Hi ray, My source is like this UOM PARENTMEASURE PARENTLEVEL CURRENT LEVEL PARENTROLLUPOPERATOR AMOUNT COST PROFIT 0 1 - DIRECTCOST COST 1 2 + 75 INCOME PROFIT 0 1 + NETINTERESTINCOME INCOME 1 2 + 100 PROFIT PROFIT 0 0 + INDIRECTCOST COST 1 2 + 10 my source data is like this.here i want to implement...

I have tried with pivot also but not working.. actually what i did i have taken only one column Column1 AAA,BBB,CCC EE,FF GG,HH,II just what idid i have loaded into sequntial file here i mentioned record delimeter string as ',' and final delimeter as 'end' then i am getting correct output Column1 AA...

Hi All,
I have installed datastage 8.0.1 in windows 2003 server.processor is intelcore duel.how can config 2nodes in my system


Thanks in advance
vin....

MY SOURCE DATA HAS THESE COLUMNS UOM PARENTMEASURE PARENTLEVEL CURRENT LEVEL PARENTROLLUPOPERATOR AMOUNT COST PROFIT 0 1 - DIRECTCOST COST 1 2 + 75 INCOME PROFIT 0 1 + NETINTERESTINCOME INCOME 1 2 + 100 PROFIT PROFIT 0 0 + INDIRECTCOST COST 1 2 + 10 I WANT OUTPUT LIKE PROFIT INCOME-EXPENSE=15 pLZ HE...

Hai, My source data CONTAINS ONLY ONE COLUMN Column1 COLUMN2 AAA,BBB,CCC TAB1 DDD TAB2 EEE,FFF,GGG,HH,II TAB3 I NEED OUTPUT LIKE COLUMN1 COULMN2 AAA TAB1 BBB TAB1 CCC TAB1 DDD TAB2 EEE TAB3 FFF TAB3 GGG TAB3 HH TAB3 II TAB3 Thanks in adavance vinsashi