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

What is apt_config in datastage?

1084

How to read multiple files using a single datastage job if files have the same metadata?

1179

What are the different options associated with dsjob command?

1372

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2677

Triggers,VIEW,Procedures

1178

Explain the importance of surrogate key in data warehousing?

1129

what is the use of surogate key in datastage

2251

What all are the different way to run a job?

1030

What is the difference between datastage and informatica?

1062

What are the types of containers and how to create them?

934

client know skid info?

2035

How the ipc stage work?

1080

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2227

How do you reject records in a transformer?

1061

What are the functionalities of link partitioner and link collector?

952