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
7822 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

What are the primary usages of datastage tool?

1060

What is datastage engine?

1166

What is the precedence of stage variables,derivations, and constraints?

1064

What are the main features of datastage?

1265

How many types of hash files are there?

1163

How do you start developing a datastage project?

1089

What is a merge?

1139

Difference between data warehousing and olap?

1073

Define Job control?

1125

What are the different plug-ins stages used in your projects?

1062

Define APT_CONFIG in Datastage?

1061

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2006

What is the difference between account and directory options ?

1165

What is the different type of jobs in datastage?

952

How to convert RGB Value to Hexadecimal values in datastage?

3981