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 |
Answer / hk
let make it more simpler use NullToValue() or NullToempty()
function ,
Is This Answer Correct ? | 3 Yes | 0 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 ? | 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 |
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Is the value of staging variable stored temporarily or permanently?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
What are some prerequisites for datastage?
What are the different database update actions available?
what is data mapping
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
source contains 2 columns comes to target 4 columns how
1)Source file contains one record, I want 100 records in target file.
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
How can u write exception handling in seq file????