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 to delete one row in target dataset
What is the difference between hashfile and sequential file?
What are the partitioning techniques available in link partitioner?
Differentiate between hash file and sequential file?
Where the datastage stored his repository?
Give an idea of system variables.
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Distinguish between informatica & datastage. Which one would you choose and why?
What is a merge in datastage?
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
Describe the main features of datastage?
Enlist various types of routines in datastage.
What are the types of hashed files in data stage
Can you explain players in datastage?
What is datastage engine?