when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
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
How to start a workflow using pmcmd command?
update strategy transformation in informatica
Explain in detail scd type 2 through mapping.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why filter transformation is an active one?
How can informatica be used for an organization?
What do you understand by a term domain?
Differentiate between a database and data warehouse?
Which files are created during the session rums by informatics server?
How do you handle two sessions in Informatica
How do you migrate data from one environment to another?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
what is mean by complex business rule ?
Explain in detail about scd type 1 through mapping.