How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 34250 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 Job control?
How a source file is populated?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Name the different types of Lookups in Datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
Triggers,VIEW,Procedures
Explain Quality stage?
sed,awk,head
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is a merge in datastage?
What is meta stage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the different layers in the information server architecture?
what is the use of surogate key in datastage
What is apt_config in datastage?
