agg-->filter-->trg2 ^ | | v seq-->copy--&

source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235

Question Posted / s

Answer Posted / s

agg-->filter-->trg2
^ |
| v
seq-->copy-->join-->trg1

agg:countrows
join:innerjoin
filter:count=1
:count>1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differentiate between datastage and informatica?

1153

How a routine is called in datastage job?

1054

Name the command line functions to import and export the DS jobs?

1106

What are the functionalities of link partitioner?

985

What is apt_config in datastage?

1093

How to manage date conversion in Datastage?

1081

What are the primary usages of datastage tool?

1028

What is the purpose of pivot stage?

1111

which r the connectors used in san?

2152

What are some prerequisites for datastage?

1052

What is the flow of loading data into fact & dimensional tables?

1027

How one source columns or rows to be loaded in to two different tables?

1082

In Datastage, how you can fix the truncated data error?

1112

What is the difference between orabulk and bcp stages?

984

Can you explain how could anyone drop the index before loading the data in target in datastage?

1456