DSXchange

I tried this and got the solution. I first used field function to split the data in col2 to different columns. then i used pivot stage to get the desired out put.. SEQ>>TRF>>PVT>>SEQ TRF: Field(DSLink3.col2,',',1) Field(DSLink3.col2,',',2) Field(DSLink3.col2,',',3) PVT: col2:= col2,col3,col4

We can use the field function in the transformer stage:
Field(DSLink3.col1,',',1)
Field(DSLink3.col1,',',2)
Field(DSLink3.col1,',',3)

for three columns. We can get the desired output.

Hi,

I tried it but it is showing the compilation error.

In order to over come this is used GetEnvironment("Environment_variable").

Now it is fine.

I am new to the data stage: Can any one explain me the reject mode in Sequential File stage: I had a simple Job: SEQ_FILE_STAGE-------->Dataset | | Seq_Reject The input are: empno,sal 101,2000 102,2003 201,5000 203,6000 300,7000 401,10000 in the Filter option i placed a command: awk -F"," ...

Thanks you Team !!!!!

Hi,

I had a doubt in hash partitioning:

Ex: Deptno
10
10
20
20
30
30
40
I want to know how the hash partition splits the Deptno data among 3 nodes.

That's highly impossible in unix Thanks, that mean's presenting the dataset after removing the duplicates in it in unix environment is impossible. Ex: Empno 1 2 2 3 O/P: Empno 1 2 3 This is Quit impossible in Unix environment Right?????

ray.wurlod wrote:Use a DataStage job. ...

Thanks but i want to do it in UNIX

ray.wurlod wrote:Use the uniq command. Dump the contents of the Data Set using orchadmin command, and pipe its output into a uniq command. ...

Thanks Ray,

I had one more doubt, I want to know how to rebuilt the Dataset.

I had a scenario where i have to remove the duplicates in the dataset in unix environment.

Ex: PNO
1
1
2
3
4
4

ray.wurlod wrote:TYPE is the DOS equivalent of the UNIX cat command. That's why Craig mentioned both. ...

Hi Ray,

I am new to the Datastage. Can u please explain how to use TYPE in-order to
combine all the files data into single file.

Hi Folks,

Can any help me in solving this scenario please.

I need multiple occurrence and single occurrence in different output links.

I/P:
10
20
10
10
20
30

O/P1:
10
10
10
20
20

O/P2:
30

Can we use "Hash file" in Parallel Jobs?
if enable any options from admin side is it posible to use "hash file" in parallel jobs?

I want this export process automated and not to give password in the run time.

All, I am trying to export datastage jobs using "ISTOOL" command in the linux script and it is working fine but I need to enter passwd "hard code" in the script. Is there any way to export jobs with out "hard coding" passwd by using ISTOOL in the linux scripting? Please...