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
- 21011 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
explain about citrix scheduling tool in datastage
What is active and passive stage?
How do you remove duplicate values in datastage?
Why do we use link partitioner and link collector in datastage?
Describe routines in datastage? Enlist various types of routines.
What is size of a transaction and an array means in a datastage?
CHANGE CAPTURE
how do u catch bad rows from OCI stage? And what CLI stands for?
How many types of sorting methods are available in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are sequencers?
What is the difference between server job and parallel jobs?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Difference between in process and inter process?
