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


Please Help Members By Posting Answers For Below Questions

What all are the different way to run a job?

639


Notification Activity

895


Terminate Activity

837


What are routines in datastage?

773


Define Job control?

675






Could anyone give brief explanation bout datastage admin

1965


What are the different kinds of views available in a datastage director?

598


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.

2726


What is merge stage?

760


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

953


What is the roundrobin collector?

635


What could be a data source system?

573


How to read the length of word in unix?

882


options available in sequence job to run,validate?

832


Can you explain repository tables in datastage?

899