I have source file which contains duplicate data,my
requirement is unique data should pass to one file and
duplicate data should pass another file how?
Answer Posted / ramachandra rao
After source use aggregator stage and use option aggregator
type is count and count the records after that use filter in
where clause count>1 ie duplicate records go to one target
and another where clause count=1 ie unique records go to
another target.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the various kinds of the hash file?
why do u need the IOS upgradation in a FC switch
What are sequencers?
How do you register plug-ins?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Define Routines and their types?
Describe the architecture of datastage?
How can you write parallel routines in datastage PX?
Define data aggregation?
How to RD using transformer?
What is ibm datastage?
sed,awk,head
How to read the length of word in unix?
What is the difference between operational data stage (ods) and data warehouse?
Which warehouse using in your datawarehouse