How do u set a default value to a column if the column value
is NULL?
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 are orabulk and bcp stages?
Explain the situation where you have applied SCD in your project?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between Datastage 7.5 and 7.0?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
How many Key we can define in remove duplicate stage?
How many types of views are there in a datastage director?
How to Remove Duplicate using SQL?
what are the devoleper roles in real time? plz tell i am new to datastage....
How do you schedule or monitoring the job?
What is a merge in datastage?
what are the errors,warnings in datastage
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What all the types of jobs you developed?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?