Error in Derived Column

• Shaun2012

  Hall of Fame

  Points: 3214

  More actions

  November 26, 2013 at 7:39 am

  #279405

  i am loading files throough csv to oracle and some one column has some null values and the database has "not null" constraint. So im using derived column to identify null values and replace with 0. But i get error message cannot insert null values.

  [Oracle Destination [17840]] Error: OCI error encountered. ORA-01400: cannot insert NULL into ("IHUBUSER"."Table_Services"."ID")

  I had use the following options:

  1) TRIM(id) == "" ? "0" : TRIM(id)

  2) len(TRIM(id)) > 0 ? TRIM(id) : "0"

  Shaun..

• Shaun2012

  Hall of Fame

  Points: 3214

  More actions

  November 26, 2013 at 9:26 am

  #1669196

  I GOT THE SOLUTION

  ISNULL(ID) ?0: ID