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
- 20563 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
table actions available in oracle connector?
How do u convert the columns to rows in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are system variables and sequencers in datastage
How to read multiple files using a single datastage job if files have the same metadata?
On which interface you will be working as a developer?
What are stage variables?
What are the different plug-ins stages used in your projects?
Explain usage analysis in datastage?
Differentiate between validated and Compiled in the Datastage?
Can we use target hash file as a lookup ?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
CHANGE CAPTURE
Triggers,VIEW,Procedures
How complex jobs are implemented in datstage to improve performance?
