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
- 35773 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 |
How do u set a default value to a column if the column value is NULL?
Why we use parameters instead of hard code in datastage.
What are the partitioning techniques available in link partitioner?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
what is the use of invokation id
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
What is difference between 8.1 , 8.5 and 9.1 ?
my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
In Datastage, how you can fix the truncated data error?
what is the best stage in datastage parller jobs to use full out join and why
Teradata 
