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 job parameters?
What are the processing stages?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Does datastage support slowly changing dimensions ?
What are the different types of lookups in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
Difference between sequential file and data set?
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the various kinds of the hash file?
how many rows sorted in sort stage by default in server jobs
What are the enhancements made in datastage 7.5 compare with 7.0?
What are routines in datastage?
Triggers,VIEW,Procedures
What is the difference between passive stage and active stage?
Name the third party tools that can be used in datastage?