Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10392 Views
- I also Faced
- E-Mail Answers
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
describe the Steps to confiure a Qlogic switch
Explain connectivity between datastage with datasources?
How a source file is populated?
How many Key we can define in remove duplicate stage?
Demonstrate experience in maintaining quality process standards?
How can we improve the performance in datastage?
root tree will find which is server job and which is parallel job?
Define ds designer?
Define meta stage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the components of datastage?
What are the types of hashed files in data stage
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How and where you used hash file?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
