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
What are the difference types of stages?
table actions available in oracle connector?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are iconv and oconv?
What is the difference between server job and parallel jobs?
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 transforms and what is the differenece between routines and transforms?
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 main differences you have observed between 7.x and 8.x version of datastage?
how can we create rank using datastage?what is the meaning of rank?
Difference between sequential file and data set?
What are datastage sequences?
Explain the importance of surrogate key in data warehousing?
Describe link sort?
why do u need the IOS upgradation in a FC switch