suppose if we have dublicate records in a table temp n now i want to pass uni

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 / shivaleela

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

Answers were Sorted based on User's Feedback

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / leo gilbert

Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1

Is This Answer Correct ?

9 Yes

0 No

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / 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

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / laksh

You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.

Is This Answer Correct ?

2 Yes

2 No

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / balaramesh

using constraint based transformation

Is This Answer Correct ?

1 Yes

5 No

Post New Answer