Page 1 of 1
Coalesce Function
Posted: Tue Apr 19, 2011 1:10 pm
by mail2krishna79
I can see Coalesce Function in Oracle 9i, Oracle 10g, Oracle 11g.
Is there any equal function in DataStge 8.1 or 8.5?
Posted: Tue Apr 19, 2011 1:56 pm
by jwiles
A very simple forum search on the term coalesce will answer your question.
Posted: Wed Apr 20, 2011 12:13 pm
by soumya5891
You can use null to value in a transformer stage or a modify stage
Coalesce Function
Posted: Wed Apr 20, 2011 1:24 pm
by ajay.vaidyanathan
You can use NullToValue() or NullToZero() in Transformer Stage or you can use NVL() at source DB Stage.
Your Choice
Regards,
Ajay
Posted: Thu Apr 21, 2011 12:46 am
by Sreenivasulu
coalesce takes the first notnull out of the input set of values. I think he is asking that sort of straighforward function in datastage ?
Regards
Sreeni
Posted: Thu Apr 21, 2011 1:53 am
by zulfi123786
A nested if then else would do.
If you dont want to see the nested if then else then enclose it in a routine to get a function like feel. all of this valid for more than one arguments, for one argument you have NullToValue()