We can use stage variable in Tran Stage IF @INROWNUM MOD 4 = 0 the

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?

Question Posted / abd

10 Answers
17071 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / abd

We can use stage variable in Tran Stage

IF @INROWNUM MOD 4 = 0 then T4
Else If @INROWNUM MOD 4 = 1 then T1
Else If @INROWNUM MOD 4 = 2 then T2
Else If @INROWNUM MOD 4 = 3 then T3

Try this

Is This Answer Correct ?

7 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

how to export or import the jobs in .ISX file

1181

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1397

What are the benefits of datastage?

1229

On which Dimension Table you implemented SCD Type in your Project

2014

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2432

How can one find bugs in job sequence?

1370

Difference between data warehousing and olap?

1073

How to RD using transformer?

1409

Explain entity, attribute and relationship in datastage?

1084

What is the difference between datastage and informatica?

1097

What is size of a transaction and an array means in a datastage?

1287

How to reverse the string using SQL?

1498

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

787

What is process model?

1957

Describe the main features of datastage?

1066