How do u set a default value to a column if the column value
is NULL?
Answer Posted / jayakumar
IF ISNULL(Column_Name.field) THEN default value ELSE
(Column_Name.field)
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is the command line function to import and export the ds jobs?
how to sort two columns in single job in datastage.
How to read multiple files using a single datastage job if files have the same metadata?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What are the primary usages of datastage tool?
options available in sequence job to run,validate?
What are the processing stages?
How many types of sorting methods are available in datastage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is difference between server jobs & parallel jobs?
Why we use surrogate key?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Define repository tables in datastage?
How do you register plug-ins?
What are orabulk and bcp stages?