DSXchange

Hi Ray source data dosent contain R2 only R1. I want in output that R2

Hi, I have a data like a ring in which a ring forms a structure of 8 or infinity symbol. The data is like this, A_point and B_point are two points and link joins those points if you draw the below data it will create 8 Ring link A_point B_point R1 F1 H F R1 F2 E F R1 F6 H G R1 F5 G E R1 F3 E A R1 F4...

sonamasd@gmail.com wrote:Take 3 variables

v1 = if col3=v2 then v3+1 else 1

v2 = col3

v3 = v1

and then in derivation of col2 give col2 : '_' : v1

I thnk it should work for ur requirement

Thanks Dear..This is working fine

Exp. Table name :School col1 col2 col3 x a 1 y a 1 z a 1 x1 a 1 x2 a 2 x3 a 2 x4 a 2 x5 a 3 I need Output LIke this .Please help me. col1 col2 col3 x a_1 1 y a_2 1 z a_3 1 x1 a_4 1 x2 a_1 2 x2 a_2 2 x3 a_3 2 x4 a_4 2 x5 a_1 3

What is the rule that determines whether an input row ends up in Group 1 or Group 2? ... The only thing which we have to concider while dividing in groups is that those all are connected. Here suppose col2 and col3 are two ends connected by wire col1, so one row represent one wire connection we hav...

Hi All, The input data is like this: F007 XYZ/001 XYZ/002 F008 XYZ/002 JKL/003 F009 JKL/003 XYZ/254 F010 XYZ/002 XYZ/567 F011 XYZ/254 OPQ/111 F012 XYZ/254 XYZ/222 F001 ABC/001 BCD/002 F002 BCD/002 ABC/003 F003 ABC/003 FGH/254 F014 ABC/002 ABC/567 F015 FGH/254 ABC/111 F016 FGH/254 ABC/222 I need the ...

Hi All, I need your valuable suggestions. I am an ETL resource majorly worked on DataStage. But as of now I am working on Talend Integration Suit an ETL. Is this good to work on this tool and later again move to DataStage or should I Stick to DataStage itself. There is any future in Talend. Tool mat...

The output should be like this: Col1 Col2 Col3 Col4 ABC/001 E0101 ABC/001_2 E4031 ABC/001 E0101 ABC/001_2 E15399 ABC/001 E0101 ABC/001_3 E022 ABC/001_2 E1360 ABC/001 E0101 ABC/001_2 E4031 ABC/001_3 E022 ABC/001_2 E5941 ABC/001 E623 ABC/001_2 E5941 ABC/001 E0101 ABC/001_2 E5941 ABC/001_3 E022 ABC/001...

Hi All, I need your help to implement a logic: I am having source data like this Col1 Col2 Col3 Col4 ABC/001 E0101 ABC/001 E4031 ABC/001 E0101 ABC/001 E15399 ABC/001 E0101 ABC/001 E022 ABC/001 E1360 ABC/001 E0101 ABC/001 E4031 ABC/001 E022 ABC/001 E5941 ABC/001 E623 ABC/001 E5941 ABC/001 E0101 ABC/0...

Ray there is not any workaround for windows7. Can anyone help me on this. Ray u was my major hope.......

Thanks for your prompt reply. Yes I have already checked the entry for 127.0.0.1 in my hosts file. But Still I am facing the same issue

Please suggest me on this.


Regards,

Hi, I have installed DataStage 7.5.2 on windows 7. Installation was done easily no error nothing. But I am not able to log on to DataStage. I have used Hostname: localhost/127.0.0.1 Username: my system username password: my system password I have tried with omit option also. But It throws an error &...

Hi Yamini,

It is not possible to get details before finishing the job. You can use DSJobreport afterjob subroutine to get any kind of details depends on the parameters you pass in the subroutine.

How this will help you...

ray.wurlod wrote:Manager client, not Designer. ...

yes Ray is correct...usage analysis is there in Manager client....

first question : if my target is database then it is fine.. if my target is sequential file then what to do...? my second question : suppose input record is 10 million, job got failed after 9 million... when i run the job again it has to update 9 million record right.. updating 9 million record is ...