Hi
If i had source like unique & duplicate records like 1,1,2,3,3,4
then i want load unique records in one target like 2,4 and i want
load duplicate records like 1,1,3,3 then can any body please send
me what is th scnario. my mail i
shek.inform@gmail.com

Answer Posted / shirish

1.For unique: Source-->SrcQualifier--> sorter (use distinct
option)--> Target
2. For duplicate : Source-->SrcQualifier-->Aggregator(group
by this column and find count also)-->filter(use count
greater than 1 )--> left outer join with source qualifier --
> target 2.
Hope i am clear.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primary and backup node?

801


Explain sessions?

681


what are the deliverables?in your project?

1769


What are the static cache and dynamic cache in informatica?

843


What does “tail –f” command do and what is its use as an Informatica admin.

724






What differs when we choose the sorted input for aggregator transformation?

667


What is source qualifier transformation in informatica?

646


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1732


What are multi-group transformations?

646


Mention few advantages of router transformation over filter transformation.

736


What is the advantage of informatica?

736


What is the need for an etl tool?

735


Explain the use of aggregator cache file?

798


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1728


State the differences between sql override and lookup override?

731