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
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 the use of hoursfromtime() function in transformer stage in datastage?
Can you explain repository tables in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the types of containers in datastage?
What is the difference between datastage and datastage tx?
How many types of sorting methods are available in datastage?
Difference between sequential file and data set?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the primary usages of datastage tool?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are stage variables?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How complex jobs are implemented in datstage to improve performance?
What is the method of removing duplicates, without the remove duplicate stage?
Nls stands for what in datastage?