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.
Major difference is the historical data which can be maintained in data warehouse instead of keeping it in your real time OLTP(database) system.Also we don't want to decrease the processing time of our oltp server for taking data for reporting and analysis purpose.Now why informatica and why other OLAP tools are required :coz companies don't want to ...