Tag: DecimalToDecimal

InfoSphere DataStage – How to calculate age in a transformer

Occasionally, there is a need to calculate the between two dates for any number of reasons. For example, the age of a person, of an asset, age of an event.  So, having recently had to think about how to do this in a DataStage Transformer, rather in SQL, I thought it might be good to document a couple of approaches, which can provide the age.  This code does it at the year level, however, if you need the decimal digits or other handling them the rounding within the DecimalToDecimal function can be changed accordingly. Age Calculation using Julian Date DecimalToDecimal((JulianDayFromDate(<>)

Continue reading
%%footer%%