what is the advantage of persistent cache? when it should be
used?
Answer Posted / san
when the table you are using for lookup is static table(
i.e. data is not changing ) and it is the huge table.
Hence reduce the session time by using the persistent cache
file/s.
Regards,
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the reporting tools and difference between them?
Can u access a repository created in previous version of Informatica?
Can there be sub steps of etl steps?
What is virtual Data Warehousing?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
What is a lookup table in etl?
what is the difference between cardinality and Nullability?
What are the different etl testing categories as per their function?
SCD2 will work on only dimension tables as well as fact Table?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
Do we need an etl tool?
dimension object created in oracle can be imported in designer?how?
How can we use external procedural logic in informatica?
how do u set partition points in the mapping?
what is the difference between cubes and package in cognos