How do u set a default value to a column if the column value
is NULL?
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 |
How to implement complex jobs in data stage?
Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?
How to find value from a column in a dataset?
What is difference between symmetric multiprocessing and massive parallel processing?
What is job control?
why do u need the IOS upgradation in a FC switch
How can one find bugs in job sequence?
How to move data set from one server to other?what are the steps to follow to do this?
difference between server shared container and parallel shared container
what is the difference between datasatge and datastage TX?
In which situations we can use normal and sparse lookup stages