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
Design a mapping to load the cumulative sum of salaries of employees into target table?
What do mean by local and global repository?
What is the function of union transformation?
What is primary and backup node?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is aggregator transformation in informatica?
What can we do to improve the performance of informatica aggregator transformation?
What is the sql query overwrite in source qualifier in informatica
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Have you worked with/created Parameter file
Explain the informatica workflow?
What are multi-group transformations?
Clarify the aggregator change?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is an Integration service in Informatica?