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
- 20262 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
What is a folder? Difference types of stages?
Describe stream connector?
Can you explain tagbatch restructure operator?
What is ds designer?
How can we improve performance of data stage jobs?
What are stage variables, derivations and constants?
Where do you see different stages in the designer?
How do u convert the columns to rows in datastage?
What are the different layers in the information server architecture?
Where do the datastage jobs get stored?
What are the types of containers in datastage?
What are the different options associated with dsjob command?
Difference between sequential file and data set?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how to implement scd2 in datastage 7.5 with lookup stage
