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
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
root tree will find which is server job and which is parallel job?
Explain how a source file is populated?
What are some prerequisites for datastage?
What are constraints and derivations?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
whom do you report?
what are the errors,warnings in datastage
What is the difference between passive stage and active stage?
Can you explain players in datastage?
What is a merge?
What are the differences between datastage and informatica?
How can we improve the performance in datastage?
What is datastage?
What are data elements?