About

You can have a lot of trouble to resolve this error: 

ORA-01400 Cannot Insert NULL into

When it's caused by a length of a string data type of zero in a target.

Powercenter Target Ora 01400

You can have this case when you use a bad ODBC driver to import your target tables