DatabaseAnswers.org Map of Fiji and surrounding area
You are Logged in as: dba_admin | logout
Home Best Practice Communities First Timers Information Catalog Performance Users Search Site Map
 
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 :-
    1. The Membership Number requires mapping to the corresponding Customer ID.
      This corresponds to a 'single view of the Customer'.
    2. 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).
  • Home Best Practice Communities First Timers Information Catalog Performance Users Search Site Map