What is a mapping table?
A mapping table is a table of correspondence between an input set of values and a set of output values according to different periods of time. You can easily maintain each row individually. A mapping table can be attached to: A catalog as master data related to a service provider.
What is mapping table in ETL?
A mapping table is used to ensure that the appropriate source value is retrieved via a given key value. For example, in the table below, if the key value is 100002, then the source value equals 247560.