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

6 Answers
9441 Views
US Technology, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the types of containers in datastage?

1143

Differentiate between hash file and sequential file?

999

What is the difference between datastage and datastage tx?

1008

Define repository tables in datastage?

1099

CHANGE CAPTURE

1257

Can you explain kafka connector?

1244

How many Key we can define in remove duplicate stage?

1310

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2444

Why we use surrogate key?

1158

What is the difference between datastage and informatica?

1059

What are the differences between datastage and informatica?

1111

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3076

On which Dimension Table you implemented SCD Type in your Project

1970

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2820

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1505