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
Highlight the main features of datastage?
What can we do with datastage director?
How to convert RGB Value to Hexadecimal values in datastage?
How many types of views are there in a datastage director?
I have a few records just I want to store data in to targets cycling way how?
what is the use of skid in reporting?
What is datastage?
CHANGE CAPTURE
What are the functionalities of link partitioner and link collector?
What are the features of datastage flow designer?
How do you remove duplicate values in datastage?
What is a datastage job?
Explain entity, attribute and relationship in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Explain the datastage parallel extender (px) or enterprise edition (ee)?