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

By: Administrator Date: September 9, 2007
6:28 pm
Categories: Informatica
Feedback
Related posts:
Comments
  • Amy

    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 13, 2009 at 11:04 pm
  • Administrator

    thanks Amy. Glad to help.

    November 22, 2009 at 9:02 pm
Leave a Comment