if inputlnk.col1%3= 1 then outputlnk.col1=inputlnk.col2 else inputlnk.col2

In the source seq file have 2 columns, i.e
input:
col1,col2
1,1
2,rajesh
3,15000
4,2
5,suresh
6,16000
7,3
8,veeru
9,17000

I want in the output like:
eno,ename,sal
1,rajesh,15000
2,suresh,16000
3,veeru,17000

any one answer this scenario

Question Posted / bharath

3 Answers
7710 Views
I also Faced
E-Mail Answers

Answer Posted / bharath

if inputlnk.col1%3= 1 then outputlnk.col1=inputlnk.col2
else inputlnk.col2

if inputlnk.col1%3= 2 then outputlnk.col2=inputlnk.col2
else inputlnk.col2

if inputlnk.col1%3= 0 then outputlnk.col3=inputlnk.col2
else inputlnk.col2

use above conditions in transformer stage
and then
change the column names using modify stage
as col1 = eno
col2 = ename
col3 = sal

let me know right answer, if i'm wrong...
..

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to perform incremental load in datastage?

1122

What are the types of views in datastage director?

1718

How will you move hashed file from one location to another location?

2090

What is the importance of the exception activity in datastage?

1014

client know skid info?

2034

how to abort the job its matain duplicates?

2531

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1133

How a server job can be converted to a parallel job?

1041

What is the difference between passive stage and active stage?

1411

Explain connectivity between datastage with datasources?

937

Differentiate between datastage and datastage tx?

1003

Could anyone give brief explanation bout datastage admin

2310

What is the difference between odbc and drs stage?

1042

Which commands are used to import and export the datastage jobs?

1358

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1680