i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like
target1
deptno,sal
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100
with out using transformerstage
Answer Posted / rafi
by using round robin partition with two nodes we can get the solution.
Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
whom do you report?
Have you have ever worked in unix environment and why it is useful in datastage?
How to reverse the string using unix?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
what is the use of skid in reporting?
How to read multiple files using a single datastage job if files have the same metadata?
What are the difference types of stages?
Describe stream connector?
in oracle target stage when we use load option and when we use upsert option?
What are the different plug-ins stages used in your projects?
how many rows sorted in sort stage by default in server jobs
Is it possible to query a hash file?
How to read the length of word in unix?
How can you write parallel routines in datastage PX?
Define ds designer?