Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saif
uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
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.
How can you define user defied event?
What is rank transformation in informatica
How to join three sources using joiner? Explain though mapping flow.
What is informatica metadata and where is it stored?
Differentiate between source qualifier and filter transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are some examples of informatica etl programs?
wat are deployement groups in informatica, how it will be used for developers
What could be the possible resons of locks by user?
How can repository reports be accessed without sql or other transformations?
Explain the scenario which compels informatica server to reject files?
While migrating the data from one environment to another environment how would you manage the connections?
What is a rank transform?
What is the scenario which compels informatica server to reject files?
