Hi,
I have columns with valuse as longitude and latitude.
we need to handle this in data stage as geographical datatype and not as varchar or char.
Could you pleae help on this
Thanks
Sudhir
Geographical data Type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Fri Sep 05, 2008 4:20 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I usually encounter them as Decimal(7,3) or subrecord containing degrees, minutes, seconds and direction. In N years of working with databases I have not encountered a data type called Geographical (though QualityStage does have a GeoMatch matching technique).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.