what is the advantage of persistent cache? when it should be used?

what is the advantage of persistent cache? when it should be
used?

Question Posted / jakki

2 Answers
4771 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the advantage of persistent cache? when it should be used?..

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

what is the advantage of persistent cache? when it should be used?..

Answer / kvikas2056

If you are using multiple look up transformations on same table, at that time you can use persistent named cache.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ETL Interview Questions

how many maximum session supports to multiload in teradata ??

0 Answers IBM,

how do u identify the changed records in operational data?

0 Answers QualTech,

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

0 Answers Accenture,

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

0 Answers

what is different between sequential batch and concurrent batch and which is recommended and why?

0 Answers

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers

Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers

what is data modeling?

0 Answers

Compare etl & elt?

0 Answers

what is the use of server manager?

0 Answers

in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?

2 Answers Accenture,

For more ETL Interview Questions Click Here