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


Please Help Members By Posting Answers For Below Questions

Have you have ever worked in unix environment and why it is useful in datastage?

657


What are the types of containers?

697


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3387


What is data partitioning?

747


Can you explain engine tier in information server?

656






Define project in datastage?

670


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2429


What is apt_config in datastage?

708


How do u convert the columns to rows in datastage?

694


Can you explain players in datastage?

713


What are the different types of lookups in datastage?

634


What are the functionalities of link partitioner?

624


Define oconv () and iconv () functions in datastage?

887


What all are the different way to run a job?

646


If you want to use a same piece of code in different jobs, how will you achieve this?

800