just add the mod function like this =MOD(inputcol|3) and then load into dif

I have a input as:

Col
1
1
2
2
3

I want 3 output as:

Output1:

1
1

Output2:

2
2

Output3:

3

i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

Question Posted / narayan

9 Answers
13941 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / narayan

just add the mod function like this =MOD(inputcol|3) and then load into different targets

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the steps required to kill the job in Datastage?

1218

What is a ds designer?

1070

Differentiate between datastage and informatica?

1182

What is the difference between passive stage and active stage?

1539

Name the different types of Lookups in Datastage?

1263

What is a quality stage in datastage tool?

1078

How rejected rows are managed in datastage?

1522

Define oconv () and iconv () functions in datastage?

1416

What are the stages in datastage?

1084

If you want to use the same piece of code in different jobs, how will you achieve it?

1158

How we can covert server job to a parallel job?

1148

Explain how a source file is populated?

1366

What are the types of jobs we have in datastage?

1075

why do u need the IOS upgradation in a FC switch

2283

Explain datastage architecture?

1403