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

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 / 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 ?    4 Yes 0 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 / 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

More Data Stage Interview Questions

How to implement complex jobs in data stage?

0 Answers  


Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,


i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  


How to find value from a column in a dataset?

0 Answers   TIAA CREF,


What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  


What is job control?

0 Answers  


why do u need the IOS upgradation in a FC switch

0 Answers   IBM,


How can one find bugs in job sequence?

0 Answers  


How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  


difference between server shared container and parallel shared container

6 Answers   CTS,


what is the difference between datasatge and datastage TX?

6 Answers  


In which situations we can use normal and sparse lookup stages

4 Answers   IBM,


Categories