http://kirtandesai.com/write Sun, 25 May 2008 16:39:52 +0000 http://backend.userland.com/rss092 en I have been busy with the new job and lot of other things. I need to start posting again. http://kirtandesai.com/write/2008/05/25/been-busy/ I got this question as a comment. Hi, In informatica one of our mappings are using oracle target table. Daily it runs in production and complete in 10 min. but suddenly its just running and running. we stopped it forcely. what could be the potential cause for its continuous run? Thanks. There could be ... http://kirtandesai.com/write/2007/12/11/informatica-issue-2/ Oracle just announced the release of Oracle Virtualization software, Oracle VM. It sounds all great and fun but it needs two machines, one for installing the server and another for managing it. I don't have two machines for this. I have two machines but this approach seems like a little ... http://kirtandesai.com/write/2007/11/15/oracle-vm/ 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 ... http://kirtandesai.com/write/2007/09/10/oracle-timestamp/ 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 http://kirtandesai.com/write/2007/09/09/nvarchar2-varchar2/ 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 ... http://kirtandesai.com/write/2007/09/08/cache/ 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 ... http://kirtandesai.com/write/2007/09/06/informatica-seq-gen-performance-issue/ 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 ... http://kirtandesai.com/write/2007/09/05/pivot-query/ I have MS Windows Vista installed on my laptop. Today, I was trying to transfer some photographs from my camera to my laptop. I also had my Oracle virtual machine on Linux running on the side. And guess what I got out of nowhere. The Blue Screen of Death. It ... http://kirtandesai.com/write/2007/08/25/windoze-has-evolved/ I just moved from Charlotte, NC to Houston, TX for a new job. I am giving consulting/contracting a (indefinite) rest. I don't know if I will ever be a consultant again but for now I will be a Full-Time employee working on 'our' in-house projects. Consulting was fun. I can't complain at all. Let's see how ... http://kirtandesai.com/write/2007/06/25/move/