How do u set a default value to a column if the column value
is NULL?
Answer Posted / jayakumar
IF ISNULL(Column_Name.field) THEN default value ELSE
(Column_Name.field)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What is a ds designer?
What is the difference between datastage and informatica?
Differentiate between operational datastage (ods) and data warehouse?
How we can covert server job to a parallel job?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Can you explain repository tables in datastage?
Where the datastage stored his repository?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is merge stage?
in oracle target stage when we use load option and when we use upsert option?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
what is repositery?
How you Implemented SCD Type 1 & Type 2 in your project?
What are the difference types of stages?