Interested to Buy Any Domain ? << Click Here >> for more details...
i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
- 13 Answers
- 20663 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / binayak mohapatra
seq-agg-copy-filt1-tgt1
Again from that agg-filt2-tgt2
In agg group=empid
count=rowcount
outputcount=empid
In agg column create another column like count_empid and map it.
in filt1 count_empid>1 and map into tag 1
then you can take input from another copy source then filter2 put a condction like count_empid=1 and map them into tgt 2
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
root tree will find which is server job and which is parallel job?
What is a ds designer?
Define orabulk and bcp stages?
Differentiate between Join, Merge and Lookup stage?
What is the precedence of stage variables,derivations, and constraints?
What are transforms and what is the differenece between routines and transforms?
Why we use surrogate key?
What are the main features of datastage?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How you Implemented SCD Type 1 & Type 2 in your project?
What is the difference between the local container and shared container?
What are the different types of lookups in datastage?
Define project in datastage?
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 "fatal error/rdbms code 3996" error?
