san


{ City } mumbai
< Country > india
* Profession *
User No # 48535
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { san }
Questions Answers Category Views Company eMail




Answers / { san }

Question { 3706 }

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


Answer

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

Question { 3221 }

how would u estimate the size of Lookup transform data and
index cache?


Answer

Just run the session once, and check for the session logs
you will get the DATA and IDX cache size.
Regards,
San

Is This Answer Correct ?    0 Yes 0 No