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
How can we use external procedural logic in informatica?
State the differences between shortcut and reusable transformation
if i have a query as flat file how can we load data to target table
what is pmrep command?
what do u do when DB time takes more?in sap bi
what is session partitioning?
What are dimensions?
What are three tier systems in etl?
what is the difference between cardinality and Nullability?
what is session partitioning?
what is dynamic insert?
what are the data modeling tools you have used?(polaris)
What is etl process? How many steps etl contains?
how would u estimate the size of Lookup transform data and index cache?
how do u set partition points in the mapping?