Sep
10
Oracle timestamp in Informatica
September 10, 2007 | Leave a Comment
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 character […]
Sep
9
nvarchar2 & varchar2
September 9, 2007 | Leave a Comment
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
Sep
8
Cache
September 8, 2007 | Leave a Comment
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, […]
Sep
6
Informatica - Seq. Gen. performance issue
September 6, 2007 | Leave a Comment
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 […]
Sep
5
Pivot Query
September 5, 2007 | 1 Comment
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 values (1,1);
insert into […]