Central Restaurant Products offers you a variety of leading products from the commercial foodservice industry?s best in class manufacturers of Waiter & Waitress Supplies.
Question: Where is the cache stored in informatica? Answer: Cache is stored in the Informatica server memory and over flowed data is stored on the disk in file format which will be automatically deleted after the successful completion of the session run. If you want to store that data you have to use a persistant cache.
A typical sizing of the Database Smart Flash Cache is two to ten times the size of SGA memory. buffers. Note that header information is stored in the SGA for each flash cache buffer -100 bytes per. buffer in exclusive mode, 200 bytes per buffer in RAC mode -so the number of available SGA buffers. is reduced as the Database Smart Flash Cache size increases, and the SGA size should be increased. accordingly.