|
|
| Mapping Specifications |
 |
|
|
|
This Page is a Template for Mapping Specifications
It provides for definition of the Data Sources, the Targets and the Mapping between them.
A Data Entry Form will be provided and a Word document will also be available.
Notes :-
- The Membership Number requires mapping to the corresponding Customer ID.
This corresponds to a 'single view of the Customer'.
- The Duration is derived, which requires specification of the Transformation involved.
|
Details of the Mapping Specifications |
| DATA FEED |
TABLE |
COLUMN NAME |
COLUMN DESCRIPTION |
GENERIC ENTITY |
GENERIC COLUMN |
| Hotel Bookings |
Customer |
Mem_Number |
Membership Number |
Customer |
customer_id |
| Hotel Bookings |
Customer |
Title |
Title |
Customer |
Title |
| |
|
|
|
|
|
| Hotel Bookings |
Bookings |
Hotel_Name |
Name of the Hotel |
Contract |
Supplier_ID |
| Hotel Bookings |
Booking |
Dt_Booked |
Date Booking Made |
Contract |
contract_agreed_date |
| Hotel Bookings |
Booking |
Dt_Arrival |
Date of Arrival |
Contract |
contract_start_date |
| Hotel Bookings |
Booking |
Num_Nights |
Number of Nights Stay |
Contract |
Duration,(derived). |
|
|
|
|
