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
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How can you write parallel routines in datastage PX?
What is data partitioning?
What is usage analysis in datastage?
How complex jobs are implemented in datstage to improve performance?
What are the partitioning techniques available in link partitioner?
what is repositery?
What are the different kinds of views available in a datastage director?
What are the difference types of stages?
If you want to use a same piece of code in different jobs, how will you achieve this?
how to implement scd2 in datastage 7.5 with lookup stage
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?