Interested to Buy Any Domain ? << Click Here >> for more details...
How do u set a default value to a column if the column value
is NULL?
- 7 Answers
- 35967 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / danny archer
If IsNull(link_name.column_name) then 'default_value' else
link_name.column_name
| Is This Answer Correct ? | 19 Yes | 4 No |
Answer / maruthi
TAKE PARALLEL TRANSFORM-DOUBLE CLICK COLUMN FIELD/U WILL
GET DS MACRO,DS FUNCTION/GO TO FUCTIONS/NULL HANDLING/NULL
TO VALUE/HETE U CAN GIVE INPUT FIELD& DEFAULT VALUE.
| Is This Answer Correct ? | 8 Yes | 1 No |
we can use
NullToValue(Col_Name, Default_Value)
or
NullToempty(Col_Name)functions in tranformaer stage.
Or
If the source is sequential file then, we have an option in
seq file ==> Formats ===> Filed Defaults ==>"Null Field
Value" --> we can set default value for it.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / hk
let make it more simpler use NullToValue() or NullToempty()
function ,
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / suresh
in the column extended properties set the desired value if
it is null
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / jayakumar
IF ISNULL(Column_Name.field) THEN default value ELSE
(Column_Name.field)
| Is This Answer Correct ? | 4 Yes | 4 No |
I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know
A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise
How can u write exception handling in seq file????
What is the purpose of pivot stage and types of containers in datastage
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
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)
whats difference between ls -ltr and ls -lrt?
Define orabulk and bcp stages?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
What are the types of views in datastage director?
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
Teradata 
