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 etl testing operations includes?
What are cubes and olap cubes?
What are the differences between sql override and update override?
what is the use of structures?how many nodes can u create in a structure?
What is tracing level?
Explain the difference between etl tool and olap tools?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What are various etl tools in the market?
how many maximum session supports to multiload in teradata ??
Explain etl mapping sheets?
Explain about the data integration suite features?
Is hadoop a etl tool?
What is initial load and what is full load?
What is full load & incremental or refresh load?
what is the main role of FI on business