Mapping Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone,

Does anyone on this group know what they mean by Mapping Fields? I'm
posting this question because I'm there are people here who work with SQL and
Oracle.

If you know or know of a site for better understanding please let me know.

Jose
 
Does anyone on this group know what they mean by Mapping Fields?
Click to expand...

Well, there are several possible meanings; only one of them to do with
agricultural cartography...

When you want to transfer records from one table to a different one, the
corresponding fields have to be mapped on to one another; eg

FName <-> FirstName
LName <-> LastName
Address1 -> Street
Salutation + ' ' + FName + ' ' + LName -> CorrespondenceName

Not all mappings are two-way!

When migrating a database from one technology, the field types have to be
mapped from one system to another; eg

VARCHAR(n) <-> Text(n)
TEXT <-> Memo
SMALLDATETIME -> DateTime
etc etc

In geographic systems, I would guess there is a data type called a
MAPPING field, although I don't have any direct experience.

Perhaps if you indicated what you actually need to know about..?

All the best


Tim F
 
Back
Top