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..........?
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
Define oconv () and iconv () functions in datastage?
What are the functionalities of link partitioner?
How to clean the datastage repository?
Define Routines and their types?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is 'reconsideration error' and how can i respond to this error and how to debug this
How one source columns or rows to be loaded in to two different tables?
What are the different types of lookups in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How to Remove Duplicate using SQL?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the difference between passive stage and active stage?
root tree will find which is server job and which is parallel job?
What is ds designer?
How can we improve the performance in datastage?