How do u set a default value to a column if the column value
is NULL?
Answer Posted / subhash
we can use
NullToValue(Col_Name, Default_Value)
or
NullToempty(Col_Name)functions in tranformaer stage.
Or
If the source is sequential file then, we have an option in
seq file ==> Formats ===> Filed Defaults ==>"Null Field
Value" --> we can set default value for it.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the different kinds of views available in a datastage director?
How to convert RGB Value to Hexadecimal values in datastage?
What are the differences between datastage and informatica?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the different type of jobs in datastage?
in oracle target stage when we use load option and when we use upsert option?
how to abort the job its matain duplicates?
How many types of sorting methods are available in datastage?
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.
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How a routine is called in datastage job?
What are system variables and sequencers in datastage
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is process model?