Interested to Buy Any Domain ? << Click Here >> for more details...
How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 35704 Views
- HP, I also Faced
- E-Mail Answers
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
How can we improve the performance in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is ibm datastage?
What can we do with datastage director?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Explain ibm infosphere information server and highlight its main features?
What is datastage?
What steps should be taken to improve Datastage jobs?
How to convert RGB Value to Hexadecimal values in datastage?
How one source columns or rows to be loaded in to two different tables?
What is the use of datastage designer?
Why we use surrogate key?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is "fatal error/rdbms code 3996" error?
Whats difference betweeen operational data stage (ods) and data warehouse?
