Data Integration Question:
Download Questions PDF

Explain various caches available in Data Integrator?

Answer:

- NO_CACHE – It is used for not caching values.

- PRE_LOAD_CACHE – Result column preloads and compares the column into the memory, prior to executing the lookup.

- PRE_LOAD_CACHE is used when the table can exactly fit in the memory space.

- DEMAND_LOAD_CACHE – Result column loads and compares the column into the memory when a function performs the execution.

- DEMAND_LOAD_CACHE is suitable while looking up the highly repetitive values with small subset of data.

Download Data Integration Interview Questions And Answers PDF

Previous QuestionNext Question
What are Data Integrator Metadata Reports?Explain Cascade?