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 / pnvnreddy
Hi Shiva ur right
---------Agg -tar1
----------/ \ -/
seq---copy--join---filter---tar2
in Agg
Agg type=count
in filter
count=1-----tar1
count>1-----tar2
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How rejected rows are managed in datastage?
how many rows sorted in sort stage by default in server jobs
How to reverse the string using unix?
What is the use of hoursfromtime() function in transformer stage in datastage?
Differentiate between validated and Compiled in the Datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the method of removing duplicates, without the remove duplicate stage?
Have you have ever worked in unix environment and why it is useful in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the steps required to kill the job in Datastage?
What is the difference between server job and parallel jobs?
what are the errors,warnings in datastage
What is size of a transaction and an array means in a datastage?
How do you generate sequence number in datastage?
Is the value of staging variable stored temporarily or permanently?