How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 34189 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / hk
let make it more simpler use NullToValue() or NullToempty()
function ,
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How you Implemented SCD Type 1 & Type 2 in your project?
Explain datastage architecture?
What is the difference between an operational datastage and a data warehouse?
sed,awk,head
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are system variables and sequencers in datastage
Why we use surrogate key?
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 process model?
Explain ibm infosphere information server and highlight its main features?
What is the differentiate between data file and descriptor file?
What are the some differences between 7.x and 8.x version of datastage?
Why do we use exception activity in Datastage?
How can we improve the performance in datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
