How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 34232 Views
- HP, I also Faced
- E-Mail Answers
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
What are the steps needed to create a simple basic datastage job?
What are the differences between datastage and informatica?
What are data elements?
Can we use target hash file as a lookup ?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Why fact table is in normal form?
Define Job control?
What is the difference between informatica and datastage?
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 is the difference between account and directory options ?
How to manage date conversion in Datastage?
What is aggtorec restructure operator?
How do you import and export data into datastage?
Can you explain repository tables in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
