Src-->SQ-->AGG-->RTR--->TG1 & TG2 In AGG Txn, take count

suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how

Question Posted / vivekk

4 Answers
11049 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / vivekk

Src-->SQ-->AGG-->RTR--->TG1 & TG2

In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1512

What are the performance considerations when working with aggregator transformation?

1155

What are the issues you have faced in your project? How did you overcome those issues?

2365

tell me 5 session failure in real time how can you solve that in your project?

2305

Explain the etl program with few examples.

1054

How to partition the Session?

1114

Define update strategy?

1234

What is expression transformation?

1107

What is lookup change?

1052

How does a rank transform differ from aggregator transform functions max and min?

1208

What is a predefined event?

1096

What are the mapping parameters and mapping variables?

1207

What all are steps in up gradation of Informatica server?

1047

What is a sorter transformation?

1103

How to load data in informatica ?

1026