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
What is data partitioning?
What are the components of ascential data stage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Differentiate between data file and descriptor file?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Can you define merge?
What is the difference between server job and parallel jobs?
What are the types of hashed files in data stage
How can we improve performance of data stage jobs?
What are the stages in datastage?
What are data elements?
Differentiate between datastage and informatica?
Define Job control?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?