How do u set a default value to a column if the column value
is NULL?
Answer Posted / maruthi
TAKE PARALLEL TRANSFORM-DOUBLE CLICK COLUMN FIELD/U WILL
GET DS MACRO,DS FUNCTION/GO TO FUCTIONS/NULL HANDLING/NULL
TO VALUE/HETE U CAN GIVE INPUT FIELD& DEFAULT VALUE.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Explain entity, attribute and relationship in datastage?
What is size of a transaction and an array means in a datastage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Explain the situation where you have applied SCD in your project?
What is the use of datastage director?
Difference between sequential file and data set?
What is staging variable?
What are the main features of datastage?
CHANGE CAPTURE
what is use of SDR function?
How to RD using transformer?
How a routine is called in datastage job?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What all are the different way to run a job?