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
What all are the different way to run a job?
Notification Activity
Terminate Activity
What are routines in datastage?
Define Job control?
Could anyone give brief explanation bout datastage admin
What are the different kinds of views available in a datastage director?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is merge stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the roundrobin collector?
What could be a data source system?
How to read the length of word in unix?
options available in sequence job to run,validate?
Can you explain repository tables in datastage?