Diffrence between static and dynamic cache

Answer Posted / sushma

If you configure lookup TRFM to use dynamic cache, then u
can use only = operator in the lookup condition,whereas LKP
TRFM using static cache can use any relational operator in
the lookup condition.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you copy the content of one repository to another repository?

804


What is the need of etl tools?

880


Under which circumstances, informatica server creates reject files?

863


While migrating the data from one environment to another environment how would you manage the connections?

913


What is meant by lookup transformation? Explain the types of lookup transformation?

772


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1929


Explain the code page compatibility?

867


Define the various join types of joiner transformation?

811


in reporting we add some new objects,how we get the count of the newly added objects to the report

2007


Enlist the tasks for which source qualifier transformation is used.

810


What does command task mean?

853


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2002


Which version configuration tool used in ur project?

3009


How many input parameters can exist in an unconnected lookup?

1335


What is the use of an aggregator cache file?

969