nvarchar2 & varchar2
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
This entry was posted on Sunday, September 9th, 2007 at 6:28 pm and is filed under Informatica. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
November 13th, 2009 at 11:04 pm
What’s up?. Thanks for the info. I’ve been digging around looking some info up for shool, but there is so much out there. Google lead me here – good for you i guess! Keep up the great information. I will be coming back over here in a few days to see if there is updated posts.
November 22nd, 2009 at 9:02 pm
thanks Amy. Glad to help.