when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
- 1 Answers
- 4297 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Could you explain what is enterprise data warehouse?
What is the fact table?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Mention few power centre client applications with their basic purpose?
What is an Integration service in Informatica?
What is standalone command task?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Suppose we do not group by on any ports of the aggregator what will be the output?
Briefly define a session task?
How do you load unique records into one target table and duplicate records into a different target table?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What does role playing dimension mean?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to delete duplicate row using informatica?
difference between repository database and repository service?
