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 |
In one project how many shared containers are created?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
how to abort the job its matain duplicates?
What is Fastly Changing Dimension?
how to design the change capture stage in(data stage parallel jobs) type 2
Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is Empno 1 2 3 4 5 6 7 8 9 10
How can we improve performance of data stage jobs?
What is the process of killing a job in datastage?
What are constraints and derivations?
I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?