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
Difference between sequential file and data set?
What is the process of killing a job in datastage?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is the difference between the local container and shared container?
how to add a new records into source?
What is merge stage?
What is a quality stage in datastage tool?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are some prerequisites for datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What are the repository tables in datastage?
What is a folder? Difference types of stages?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Why do we use link partitioner and link collector in datastage?
What is the importance of the exception activity in datastage?