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
- 35430 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
Define data aggregation?
What are the stages in datastage?
how to abort the job its matain duplicates?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the functionalities of link partitioner?
How can one find bugs in job sequence?
What are routines in datastage?
Difference between in process and inter process?
How a server job can be converted to a parallel job?
Lookup constraints
Can you explain tagbatch restructure operator?
Does datastage support slowly changing dimensions ?
whom do you report?
What is the difference between passive stage and active stage?
What all the types of jobs you developed?
