Reading EMPTY values in NOT NUllable column
Posted: Tue Nov 28, 2017 2:27 am
I am reading the data from SQL Server and dumping into Oracle. I am using RCP while reading and writing. For reading and Writing both I am using ODBC connector stage.
Problem is, there are some NOT NULLABLE columns having EMPTY values in source and the job is getting aborted while loading these EMPTY values. Its gives below error:
ORA-01400: cannot insert NULL into <Not Nullable column name>
The metadata is same in Source and Target (Not null-able)
FYI: I am creating the table in Oracle using ODBC stage (Table Action = Create, Write Mode = Insert)
Problem is, there are some NOT NULLABLE columns having EMPTY values in source and the job is getting aborted while loading these EMPTY values. Its gives below error:
ORA-01400: cannot insert NULL into <Not Nullable column name>
The metadata is same in Source and Target (Not null-able)
FYI: I am creating the table in Oracle using ODBC stage (Table Action = Create, Write Mode = Insert)