How do u set a default value to a column if the column value is NULL?

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

How do u set a default value to a column if the column value
is NULL?

Question Posted / ram

7 Answers
32913 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How do u set a default value to a column if the column value is NULL?..

Answer / danny archer

If IsNull(link_name.column_name) then 'default_value' else
link_name.column_name

Is This Answer Correct ?

19 Yes

4 No

How do u set a default value to a column if the column value is NULL?..

Answer / maruthi

TAKE PARALLEL TRANSFORM-DOUBLE CLICK COLUMN FIELD/U WILL
GET DS MACRO,DS FUNCTION/GO TO FUCTIONS/NULL HANDLING/NULL
TO VALUE/HETE U CAN GIVE INPUT FIELD& DEFAULT VALUE.

Is This Answer Correct ?

8 Yes

1 No

How do u set a default value to a column if the column value is NULL?..

Answer / hk

let make it more simpler use NullToValue() or NullToempty()
function ,

Is This Answer Correct ?

3 Yes

0 No

How do u set a default value to a column if the column value is NULL?..

Answer / subhash

we can use
NullToValue(Col_Name, Default_Value)
or
NullToempty(Col_Name)functions in tranformaer stage.

Or
If the source is sequential file then, we have an option in
seq file ==> Formats ===> Filed Defaults ==>"Null Field
Value" --> we can set default value for it.

Is This Answer Correct ?

3 Yes

0 No

How do u set a default value to a column if the column value is NULL?..

Answer / suresh

in the column extended properties set the desired value if
it is null

Is This Answer Correct ?

2 Yes

0 No

How do u set a default value to a column if the column value is NULL?..

Answer / jayakumar

IF ISNULL(Column_Name.field) THEN default value ELSE
(Column_Name.field)

Is This Answer Correct ?

4 Yes

4 No

How do u set a default value to a column if the column value is NULL?..

Answer / sharman

Yes maruthii you r right...

Is This Answer Correct ?

0 Yes

1 No

Post New Answer