Nullability changes during Metadata import

jreddy · Post by **jreddy** » Thu Jul 19, 2007 1:47 pm

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..

thebird · Post by **thebird** » Thu Jul 19, 2007 1:52 pm

Are you doing any aliasing in the SQL query on the field throwing the warning?

ArndW · Post by **ArndW** » Thu Jul 19, 2007 7:40 pm

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?

jreddy · Post by **jreddy** » Fri Jul 20, 2007 6:28 am

thebird..I am not doing any aliasing for the column that throws the error!