Page 1 of 1

Nullability changes during Metadata import

Posted: Thu Jul 19, 2007 1:47 pm
by jreddy
I tried importing metadata via ODBC, plugin-9iOCI and also with a Orchestrate schema definition import, but in any case, When i read from the table, though the column definition(in the stage) says NUllability NO, i get a warning saying that i am implicitly converting nullable source to non-nullable..

I dont want to use Modify stage, as my main concern is that though metadata defines it and also the table definition say that this column is NOT Nullable, how come the source oracle stage still sees it as a Nullable column?

any suggestions?

I am just trying to read this table and do a straight dump into a Dataset..

Posted: Thu Jul 19, 2007 1:52 pm
by thebird
Are you doing any aliasing in the SQL query on the field throwing the warning?

Posted: Thu Jul 19, 2007 7:40 pm
by ArndW
So you have a column that, according to the DDL in the database, is NOT NULLABLE, and when you import that via the manager it also states NOT NULLABLE yet when you view or run a job using that metadata you get the warning message regarding the nullable-to-not-nullable conversion? How did you get the DDL description?

Posted: Fri Jul 20, 2007 6:28 am
by jreddy
thebird..I am not doing any aliasing for the column that throws the error!