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
Differentiate between odbc and drs stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
describe the Steps to confiure a Qlogic switch
What is the difference between passive stage and active stage?
Difference between data warehousing and olap?
What are the processing stages?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
I have a few records just I want to store data in to targets cycling way how?
What is difference between symmetric multiprocessing and massive parallel processing?
Name the third party tools that can be used in datastage?
What are the functionalities of link partitioner?
CHANGE CAPTURE
How a source file is populated?
How many areas for files does datastage have?
Define APT_CONFIG in Datastage?