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
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
Explain about hash partitioning?
What are dimensions?
what is the use of server manager?
how would u estimate the size of Aggregator transform data and index cache?
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 are the types of Data Warehouse applications?
what are the data modeling tools you have used?(polaris)
Explain do we need an etl tool?
Difference between flat files and relational sources?
what is pmrep command?
what is session partitioning?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
Explain do we need an etl tool? When do we go for the tools in the market?
what is session partitioning?