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 aggtorec restructure operator?
Why fact table is in normal form?
How do you schedule or monitoring the job?
What is the difference between hashfile and sequential file?
What are the partitioning techniques available in link partitioner?
What are the steps needed to create a simple basic datastage job?
What is the differentiate between data file and descriptor file?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how to implement scd2 in datastage 7.5 with lookup stage
How to read the length of word in unix?
root tree will find which is server job and which is parallel job?
How can we improve the performance in datastage?
What are some different alternative commands associated with "dsjob"?
what is the difference between == and eq in UNIX shell scripting?
Can you explain how could anyone drop the index before loading the data in target in datastage?