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

project Steps,hits, Project level HArd things,Solved methods?

2123

How many types of views are there in a datastage director?

1280

Differentiate between odbc and drs stage?

1046

How do you register plug-ins?

960

What is the use of datastage director?

1013

What are the different types of lookups in datastage?

1052

How do you schedule or monitoring the job?

1204

Differentiate between data file and descriptor file?

1050

how do u catch bad rows from OCI stage? And what CLI stands for?

2795

What is "fatal error/rdbms code 3996" error?

1260

What is the purpose of pivot stage and types of containers in datastage

1033

I have a few records just I want to store data in to targets cycling way how?

2352

what is the use of materialized view?

1561

What is ibm datastage?

965

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3164