when will we use unconnected & connected lookup? How it
will effect on the performance of mapping?
Answer Posted / nag
We use connected transformation
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
Differentiate between reusable transformation and mapplet.
What is mapping debugger?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What differs when we choose the sorted input for aggregator transformation?
What is joiner transformation in informatica?
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 ?
What are the guidelines to be followed while using union transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Define the various join types of joiner transformation?
What could be the possible resons of locks by user?
can we override a native sql query within informatica? How do we do it?
Target increases every day even though no new record was inserted
What are the modules in Power Center
What do you mean by enterprise data warehousing?