Default values in target database

[yaminids]

Hello,

I am trying to map some columns in source table to columns in target table. The problem is that for some target table columns there are no source columns specified. I am asked to fill that columns with defaults like 'Null' or to just leave them blank. My question is how can we leave the columns blank while mapping them in 'Transformer' stage, as the stage does'nt allow any columns without derivation.
Can anyone suggest me the correct way to leave some columns blank in the tables of target database.

[KeithM]

You can enter values in the derivation to get the results you want. You don't have to map a column from your source table to each column in the target table.

If you want a blank just put '' in the derivation. If you want a null value in your target enter @NULL in the derivation.

[kduke]

You can change your metadata to be nullable. You could change your derivation to check for null.

if IsNull(input.column) then "default value" else input.column

[ray.wurlod]

You can organize for default values to be set in the target database itself. Every column definition is able to have a DEFAULT clause.

Other than that, if the column is updated by DataStage, then DataStage must generate a value with which to update that column. It doesn't matter what you do or how you do it, DataStage must generate a value.

Presumably you want to allocate a default value (a constant) if some particular condition is true - usually that the incoming value from source is NULL. As others have suggested,

Code: Select all

If IsNull(Source.Value) Then defaultvalue Else Source.Value 

is a suitable technique.

[yaminids]

Thank you all for your help. Have a nice day.

Hello,

I am trying to map some columns in source table to columns in target table. The problem is that for some target table columns there are no source columns specified. I am asked to fill that columns with defaults like 'Null' or to just leave them blank. My question is how can we leave the columns blank while mapping them in 'Transformer' stage, as the stage does'nt allow any columns without derivation.
Can anyone suggest me the correct way to leave some columns blank in the tables of target database.