How you load distinct records into one target and duplicate records into anothe

How you load distinct records into one target and duplicate
records into another target?

Question Posted / manojdubba

3 Answers
15040 Views
Mphasis, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How you load distinct records into one target and duplicate records into another target?..

Answer / moorthy. g

S-SQ-Exp-Rtr-Tgt1/Tgt2

Exp:

flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;

Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values

Best Regards,
Manthiramoorthy. G

Is This Answer Correct ?

4 Yes

0 No

How you load distinct records into one target and duplicate records into another target?..

Answer / hema

With an Expression transformation flag the 1st record of a
group with some value say "VALID" and flag the other
records of the same group with value say "DUPLICATES". Then
pass this through a router and then to the different
Targets.(1st target - records with VALID flag and in 2nd
target - records with "DUPLICATES" flag)

Is This Answer Correct ?

5 Yes

2 No

How you load distinct records into one target and duplicate records into another target?..

Answer / shaik

Create a mapping with two targets.

> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.

> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.

Is This Answer Correct ?

5 Yes

3 No

Post New Answer