Interested to Buy Any Domain ? << Click Here >> for more details...
How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 35740 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
What is quality stage?
Differentiate between datastage and datastage tx?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Why do we use exception activity in Datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
State the difference between an operational datastage and a data warehouse?
What is the difference between informatica and 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
Differentiate between data file and descriptor file?
How can we improve the performance in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
How one source columns or rows to be loaded in to two different tables?
What is a quality stage in datastage tool?
What are transforms and what is the differenece between routines and transforms?
What is the roundrobin collector?
