How do u set a default value to a column if the column value
is NULL?
Answer Posted / hk
let make it more simpler use NullToValue() or NullToempty()
function ,
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How rejected rows are managed in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Where the datastage stored his repository?
What are data elements?
What are the types of containers?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the command line function to import and export the ds jobs?
How do you generate sequence number in datastage?
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 ?
What are the primary usages of datastage tool?
What is apt_config in datastage?
How and where you used hash file?
What steps should be taken to improve Datastage jobs?
How do you run datastage job from the command line?
What are the enhancements made in datastage 7.5 compare with 7.0?