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


Please Help Members By Posting Answers For Below Questions

How rejected rows are managed in datastage?

928


how many rows sorted in sort stage by default in server jobs

3566


How to reverse the string using unix?

2818


What is the use of hoursfromtime() function in transformer stage in datastage?

591


Differentiate between validated and Compiled in the Datastage?

653






disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2088


What is the method of removing duplicates, without the remove duplicate stage?

592


Have you have ever worked in unix environment and why it is useful in datastage?

657


Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

634


What are the steps required to kill the job in Datastage?

691


What is the difference between server job and parallel jobs?

676


what are the errors,warnings in datastage

2160


What is size of a transaction and an array means in a datastage?

745


How do you generate sequence number in datastage?

629


Is the value of staging variable stored temporarily or permanently?

585