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 data file and descriptor file?

1060

What are some different alternative commands associated with "dsjob"?

1169

what is 'reconsideration error' and how can i respond to this error and how to debug this

2633

What is the command line function to import and export the ds jobs?

1153

Can you explain tagbatch restructure operator?

1178

How you can fix the truncated data error in datastage?

1793

Why do we use link partitioner and link collector in datastage?

1138

Explain how a source file is populated?

1367

Differentiate between validated and Compiled in the Datastage?

1282

What is a folder? Difference types of stages?

1178

What is the precedence of stage variables,derivations, and constraints?

1086

What are the functionalities of link partitioner?

1022

What are the features of datastage flow designer?

1040

what is the use of materialized view?

1572

How do you reject records in a transformer?

1125