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
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are the types of hashed files in data stage
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the use of datastage director?
Define Merge?
Define meta stage?
What is oci?
What is the purpose of pivot stage and types of containers in datastage
What is the purpose of pivot stage?
How to reverse the string using SQL?
Triggers,VIEW,Procedures
What are the different types of lookups in datastage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the types of views in datastage director?
How to reverse the string using unix?