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
- 20100 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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
CHANGE CAPTURE
Where do you see different stages in the designer?
What is the difference between server job and parallel jobs?
How a routine is called in datastage job?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is size of a transaction and an array means in a datastage?
Name the different sorting methods in datastage.
What are the types of hashed files in data stage
what is the custome stage in datastage? how can we impliment that one? plz tell me
client know skid info?
How do you import and export the datastage jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are iconv and oconv?
How to implement complex jobs in data stage?
