Answer Posted / sandhya
detail outer is correct--keeps all the rows from master and
only matching rows from detail.for confirmation see join
types in joiner transformation designer guide
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
In how many ways we can create ports?
What is an unconnected transformation?
What is a snowflake schema?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is dynamic cache?
What is an aggregator transformation?
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
What is workflow monitor?
Why do you use Mapping Parameter and mapping variable?
How to improve the performance of a session using sorter transformation?
How can you define user defied event?
In informatica workflow manager, how many repositories can be created?
When do you use sql override in a lookup transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?