Interested to Buy Any Domain ? << Click Here >> for more details...
one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?
- 8 Answers
- 13277 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sudheer
- aggregator -
seq. file - copy join - filter - seq.op
in arrg - cnt rows
in join - left outer join - left as seq.file data
in filter - where cond. - cnt>1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you implement SCD2 using join, transformer and funnel stage?
How the ipc stage work?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between operational data stage (ods) and data warehouse?
What is meta stage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is difference between symmetric multiprocessing and massive parallel processing?
Where do you see different stages in the designer?
What is the method of removing duplicates, without the remove duplicate stage?
What are the partitioning techniques available in link partitioner?
How do u convert the columns to rows in datastage?
How do you reject records in a transformer?
what is the custome stage in datastage? how can we impliment that one? plz tell me
explain about citrix scheduling tool in datastage
