1.why we need to use unconnected transformation?
2.where we can static chach,dynamic chach
Answer Posted / sreenu
Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.
Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
What is union transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the prerequisite tasks to achieve the session partition?
How do you migrate data from one environment to another?
How to do the error handling of if ur source is flatfiles?
What are data-driven sessions?
How an expression transformation differs from aggregator transformation?
What are the advantages of using informatica as an etl tool over teradata?
Difference between Data and Index Caches?
Design a mapping to load a target table with the following values from the above source?
Explain constraint based loading in informatica
What is rank index in rank transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?