Answer Posted / swetha
When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What are the differences between a connected lookup and unconnected lookup?
Can you use flat files in Mapplets.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the issues you have faced in your project? How did you overcome those issues?
Explian the Process of deployment groups in informatica
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Write the program through which the records can be updated?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is degenerated dimension?
What is sequence generator transformation in informatica?
Explain joiner transformation in informatica