jayanthidinesh

 Profile Answers by jayanthidinesh 

• Jan 7th, 2009

 

If the target column is coming as NULL value from source, You can give a default value by adding a column in expression transformation ad below.

COLUMN_NAME (The datatype and value filed will populate. Change it) '-1' or 'DEFAULT'

The value to the target column is defaulted to value of -1 or it can be mentioned as default depending on the datatype in the target table.

Either the column can be directly fetched from source table and given a default value or Add an column in the expression transformation by providing default value to link to target table.

Regards,

Jayanthi

mythili.ki

 Profile Answers by mythili.ki 

• Jul 27th, 2009

 

Create a port in expression transformation and do calculation whatever you need for the target or assign default value for that port and just pass that to target.