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
What is primary and backup node?
Explain sessions?
what are the deliverables?in your project?
What are the static cache and dynamic cache in informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
What differs when we choose the sorted input for aggregator transformation?
What is source qualifier transformation in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are multi-group transformations?
Mention few advantages of router transformation over filter transformation.
What is the advantage of informatica?
What is the need for an etl tool?
Explain the use of aggregator cache file?
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?
State the differences between sql override and lookup override?