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.
Using Informatica Stored Procedure Transformation. Stored Procedure Transformation - as the name suggests is used to execute stored procedures through Informatica ETL. It can also be used to call functions to return calculated values. The Stored Procedures that are to be executed should be pre-built on the database which can be connected through Informatica.