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 generates a flat file dump and then do a bcp in to sybase. So, as part of the flat file gen, I am trying to convert the current/datetime to a varbinary(8) form. So, eventually it just gets bcp'in. We have to options. (1) Informatica converting sysdate to a varbinary form (which looks like INFA won't be able to do it). (2) The source (oracle dB) does this-I tried this option as well, but no luck.