Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

conversion of nvarchar2 to varchar from oracle to postgres.

rvJun 27 2012
Hi,
I am loading data from oracle to postgres through odi 11g.
I have a table in oracle whose columns have nvarchar2 datatype and its corresponding in postgres is varchar.
But when these columns contain null values then the odi is giving an error of unknown type values when loading to postgres and when the data is other then null then the data is getting loaded without a problem.
Also there is no not null constraint present on the postgres or oracle level.
Then why the null data is not getting transfer to the postgres through odi 11g.

Please suggest.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2012
Added on Jun 27 2012
#business-intelligence-applications, #data-integrator, #system-management-and-integration
0 comments
533 views