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 do u reduce warnings

1 Answers   CGI,


client know skid info?

0 Answers   NTT Data,


what is the use of materialized view?

0 Answers   CTS,


i 10 jobs first two jobs are runing in 2nodes,next 2 jobs are running in 4 nodes, next 4 jobs are running in 6 nodes and the remaining jobs are running on 10 nodes. how to change the node configuration?

2 Answers  


What are the benefits of datastage?

0 Answers  


how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,


HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?

1 Answers   Infosys,


1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,


State the difference between an operational datastage and a data warehouse?

0 Answers  


How did you reconcile source with target?

2 Answers   HP,


i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

5 Answers   HSBC,


Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,


Categories