Informatica/sas Help

[OneWayMyWay]

Is there a function similar to GEODIST as in SAS to calculate Geographical Distance in Informatica?
GEODIST function in SAS computes the geodetic distance between any two arbitrary latitude and longitude coordinates. Input values can be expresses in degrees or in radians.

[_poori]

[ds_anilb]

help

[sri.madasi]

[quote name='_poori' timestamp='1352859919' post='1302792807']

[/quote]
[img]http://25.media.tumblr.com/tumblr_mdbuwrstbJ1qby975o1_500.gif[/img]

[bokuboy]

[ETL]

Nope u don have GEODIST function in INFA.

However u can build Haversine formula in INFA to calculate the GEO distance (assuming u have Lat and Long in radians).

[OneWayMyWay]

[quote name='ETL' timestamp='1352862235' post='1302792941']
Nope u don have GEODIST function in INFA.

However u can build Haversine formula in INFA to calculate the GEO distance (assuming u have Lat and Long in radians).
[/quote]


Should we use Haversine formula in java transformation to acheive this?

[ETL]

[quote name='OneWayMyWay' timestamp='1352863336' post='1302793024']
Should we use Haversine formula in java transformation to acheive this?
[/quote]


Yupp.. U have to use Java only as informatica does not support atan2 fxn...May be a stored proc also will do the business.