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 / me
seq----> copy
from copy stage one link to aggregator apply count rows option ---> filter (on count rows output 1 ) send as reference to look up below
from copy stage second link to lookup
apply filter
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is ibm datastage?
What a datastage macro?
How can we improve the performance in datastage?
EXPLAIN SCD
Have you have ever worked in unix environment and why it is useful in datastage?
What are the different kinds of views available in a datastage director?
What is the differentiate between data file and descriptor file?
how to write server Routine coding?
What are the different common services in datastage?
What is the flow of loading data into fact & dimensional tables?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the difference between server job and parallel jobs?
Give an idea of system variables.
What are the components of ascential data stage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?