How do u set a default value to a column if the column value
is NULL?
Answer Posted / suresh
in the column extended properties set the desired value if
it is null
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How rejected rows are managed in datastage?
Describe routines in datastage? Enlist various types of routines.
What is the difference between odbc and drs stage?
Can you define merge?
Does datastage support slowly changing dimensions ?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Define meta stage?
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 ?
Can you explain tagbatch restructure operator?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is a ds designer?
Explain entity, attribute and relationship in datastage?
What are the different layers in the information server architecture?
how many rows sorted in sort stage by default in server jobs
What are the types of views in datastage director?