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 / thippareddy.p
From source copy the data into sets using copy or peak
stage then for each copy stage use remove duplicate stage
with duplicate to retain first and last you will get
desired output.....
Hope thios will help u.......
Is This Answer Correct ? | 1 Yes | 16 No |
Post New Answer View All Answers
What is difference between server jobs & parallel jobs?
Explain Quality stage?
What are iconv and oconv?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Explain connectivity between datastage with datasources?
How many Key we can define in remove duplicate stage?
What is the difference between in process and inter process?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the purpose of interprocessor stage in server jobs?
Why do you need stage variables?
What are the main features of datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Describe routines in datastage? Enlist various types of routines.
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How do you run datastage job from the command line?