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
Which development components of informatica have the highest usage?
What is informatica worklet?
What are the different clients of powercenter?
Can we override a native sql query within informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
Which are the different editions of informatica powercenter that are available?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Write the different tools in the workflow manager?
Explain the different lookup methods used in informatica?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Explain constraint based loading in informatica
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What is the session task and command task?
Enlist the advantages of informatica.
Explain the types of transformations?