How do u set a default value to a column if the column value
is NULL?
Answer Posted / danny archer
If IsNull(link_name.column_name) then 'default_value' else
link_name.column_name
Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
Is it possible to query a hash file?
What are the types of views in datastage director?
Whats difference betweeen operational data stage (ods) and data warehouse?
How rejected rows are managed in datastage?
How to perform incremental load in datastage?
How to Remove Duplicate using SQL?
What is the different type of jobs in datastage?
Define Routines and their types?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the some differences between 7.x and 8.x version of datastage?
what is repositery?
How to reverse the string using unix?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the features of datastage flow designer?