How do u set a default value to a column if the column value
is NULL?
Answer Posted / danny archer
If IsNull(link_name.column_name) then 'default_value' else
link_name.column_name
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
How many types of stage?
How you Implemented SCD Type 1 & Type 2 in your project?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
I have a few records just I want to store data in to targets cycling way how?
describe the Steps to confiure a Qlogic switch
What are stage variables, derivations and constants?
whom do you report?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How to implement complex jobs in data stage?
what is repositery?
root tree will find which is server job and which is parallel job?
What is the difference between the local container and shared container?
how do u catch bad rows from OCI stage? And what CLI stands for?
What is difference between server jobs & parallel jobs?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?