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.
Informatica takes 1st record [from Detail table] and then takes the values of deptno which is there in record1 and informatica searches it in Index cache..if this deptno found in Index cache, then informatica gets the related value from Data cache and finally passes it to the Down-stream of the Joiner Transformation.