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


Please Help Members By Posting Answers For Below Questions

whom do you report?

1496


Have you have ever worked in unix environment and why it is useful in datastage?

639


How to reverse the string using unix?

2788


Difference between ‘validated ok’ and ‘compiled’ in data stage?

663


what is the use of skid in reporting?

1947






How to read multiple files using a single datastage job if files have the same metadata?

728


What are the difference types of stages?

614


Describe stream connector?

818


in oracle target stage when we use load option and when we use upsert option?

1743


What are the different plug-ins stages used in your projects?

613


how many rows sorted in sort stage by default in server jobs

3548


Is it possible to query a hash file?

1552


How to read the length of word in unix?

876


How can you write parallel routines in datastage PX?

610


Define ds designer?

758