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
Explain the etl program with few examples.
tell me 5 session failure in real time how can you solve that in your project?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain pushdown optimization and types in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Enlist the differences between database and data warehouse.
What is the Rank index port in Rank transformation?
What is a dimensional model?
Differentiate between reusable transformation and mapplet.
where to store informatica rejected data?
tell me about your project functionality
Enterprise data warehouse your projects phase by phase explain?
How might you approve all mappings in the archive all the while?
What are the components of workflow manager?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how