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 / kiran kumar
hi
put the hash partition in active stage then
make three node configuration then u got the output
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How one source columns or rows to be loaded in to two different tables?
Can you implement SCD2 using join, transformer and funnel stage?
Difference between in process and inter process?
What is the difference between operational data stage (ods) and data warehouse?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the purpose of pivot stage?
How to RD using transformer?
what is use of SDR function?
How many areas for files does datastage have?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the difference between orabulk and bcp stages?
What is the project in datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How to reverse the string using SQL?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?