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

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

Question Posted / jayakumar

Answer Posted / jayakumar

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

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

973

What is the difference between in process and inter process?

676

What are the difference types of stages?

626

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

631

What are the main features of datastage?

667

How can we improve performance of data stage jobs?

618

What is size of a transaction and an array means in a datastage?

744

What are the types of views in datastage director?

1249

What are the main differences you have observed between 7.x and 8.x version of datastage?

626

Can you highlight the main features of ibm infosphere information server?

642

Is possible to create skid in dim,fact tables?

2194

Define data aggregation?

675

How do u convert the columns to rows in datastage?

694

what are the errors,warnings in datastage

2157

Define meta stage?

789