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

Clarify the utilization of aggregator cache record?

785


What is decode in informatica?

835


Can you use flat files in Mapplets.

2431


can anyone suggest best free Talend data integration training online

1492


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1548


How does a sorter cache works?

807


Write the unconnected lookup syntax?

851


How to do unit testing in informatica? How to load data in informatica ?

892


How can we store previous session logs?

792


Performance tuning in UNIX for informatica mappings?

2348


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1810


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1371


Why is sorter an active transformation?

888


what is the size of your data warehousing?

1873


What are the main issues while working with flat files as source and as targets ?

924