How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / dwhlabs
1> using dynamiclookup concept
2> using variable concept
First solution
source > sorter >dynamic lookup > filter > Target1 and
Target2
for more abt informatica mappings ... www.dwhlabs.in
Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Repository user profiles
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
In development project what is the process to follow for an etl developer from day1
Clarify the utilization of aggregator cache record?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the sql query overwrite in source qualifier in informatica
What are junk dimensions?
What all join we can perform in LOOKUP transformation?
How we can use union transformation?
How can we update a record in the target table without using update strategy?
What are the tasks that can be performed using sq?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How can one identify whether mapping is correct or not without connecting session?