Interested to Buy Any Domain ? << Click Here >> for more details...
How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 35477 Views
- HP, I also Faced
- E-Mail Answers
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 ? | 4 Yes | 0 No |
Post New Answer View All Answers
Differentiate between hash file and sequential file?
If you want to use a same piece of code in different jobs, how will you achieve this?
How a server job can be converted to a parallel job?
what are the errors,warnings in datastage
What are the job parameters?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
what is the use of skid in reporting?
How do you schedule or monitoring the job?
What is job control?
How complex jobs are implemented in datstage to improve performance?
What all are the different way to run a job?
What are iconv and oconv?
What are data elements?
What are the repository tables in datastage?
Have you used Unstructured data?
