Informatica Scenario Segregating Unique and Duplicate Rows:Best 2 approaches

The Video demonstrates how the unique and duplicate records can be segregated from source and loaded to 2 different targets.It shows 2 approaches which covers for both table and flat file as source
#InformaticaPowercenter #InformaticaTutorials #TechCoach

[chitravable]

very clear and quick explanation. Thanks

[omkarkulkarni]

What if my rows are
A B X
A B Y

Will it consider duplicate since you have group by only col1 and col2

[vaibhavgautam]

Another variation could be : SQ query: select col1, col2, col3, count(*) OVER (PARITION BY col1, col2, col3) from scenario3. This will give you both the duplicating rows instead of just one.

[swapnilmahalle]

Hi...Nice explaination. However, if out of duplicate records if I want to load 1 version into target (to avoid losing data) along with the duplicate table as shown in example below, how you will handle it?


Source
Col1 Col2 Col3
A B C
A B C
P Q R
X Y Z

Target Unique :
Col1 Col2 Col3
A B C
P Q R
X Y Z

Target Duplicate :
Col1 Col2 Col3
A B C

[pankhuriverma]

could you please explain with flat file as source through expression transformation in detail.

[Shivraj-gtin]

Aggregate transformation should be the last transformation right?? Then how router is used here after aggregator???

[ameysa]

Nice explanation with two different approaches

[TheSwatirock]

nice explanation...pls post more videos based on in string and sub string

[sudeshnanath]

If a file contains some special characters in records how to separate these characters ....please give me a in advance

[AlokMauryaCSEengineer]

But u did not use group by for all the three cols in aggregator. Plz explain why