OBIEE Question
918398Feb 18 2012 — edited Feb 18 2012Hi all
I came through a question in an interview...any views or suggestions on this question would really appritiable
Lets say that you have three tables joined to each other which have been set to be cacheable at physical layer with Table 1 set at cache persistence time 45 min, Table 2 with 60 min and Table 3 with 30 min. You ran your answers request at 9 AM and again at 9:15 AM and again at 9:45 AM. Is the result set the same for all these 3 runs at different times? If so, Why? If Not, why not? There are transactions going on and data is being updated in these tables almost every 10 min.
Regards
Raju