Kirtan Desai

To extract values from an oracle table column of timestamp datatype, you need to convert it to a character datatype since the Oracle Timestamp datatype is not currently supported by PowerCenter. To extract the value do the following. Use SQL override and function to_char, provided by oracle, to convert the values of a field to [...]

Informatica imports all VARCHAR2 fields as nVARCHAR2. This is a big deal. Especially when you are using update strategy to perform update-else-insert operations on target columns that are of VARCHAR2 datatype. One could expect noticable performance gain after converting all target column definitions for VARCHAR2 columns in Informatica. Kirtan

Informatica uses cache files for various transformation wherever it needs to store data throughout the life of the mapping. For all these transformations Informatica uses Index Cache and Data Cache. This is done using either memory alone or using memory and physical disks. When the cache settings are calculated correctly and enough room is provided, [...]

Someone emailed me yesterday with a “never heard of”, at least for me, Informatica performance issue. The message said that they only have a sequence generator that is adding something to the data in the mapping. Everything else is coming straight from the source. The session took less than a minute to execute without a [...]

So how to pivot data in a table? I was asked about this by someone at work today. Let’s say you have a table that looks like following. I have included create and insert statements so that you can see it and understand it yourself. Create table t1 (a number, b number); insert into t1 [...]

(You may find similar contents in Informatica Documentation. I have borrowed some description from the manuals to keep single version of truth alive.)  Overview: Informatica PowerCenter Connect for Web Services works as a consumer of a Web Service. You can use PowerCenter Connect for Web Services to integrate with PowerCenter to read data from a [...]

Informatica Performance Tuning I have gathered this list over time while working at different client sites. It is not necessarily my list. But it definitely is a good list. If you don’t agree with anything below, don’t follow it. Anyways, here it goes…. INFORMATICA BASIC TUNING GUIDELINES The following points are high-level issues on where [...]