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
How to join three sources using joiner? Explain though mapping flow.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Slowly changing dimensions, types and where will you use them
What if the source is a flat-file?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain what are the different versions of informatica?
How can we use mapping variables in informatica? Where do we use them?
What are mapplets?
Define joiner transformation?
Reusable transformation and shortcut differences
What is meant by pre and post session shell command?
What differs when we choose the sorted input for aggregator transformation?
How to create or import flat file definition in to the warehouse designer?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the function of look up transformation?