Source to target data mapping matrix Table C-1 shows the source to target data mapping matrix used to consolidate the Oracle and SQL Server data marts into DB2. Table C-1 Source to Target Data Mapping Matirx Table name Column name Data type Data Mart Name Table name Column Data type (conversion and metadata) Surrogate key generated by edw Natural key for employee Data type conversion Data type conversion Data type conversion Data type conversion EDW Table Column EDW Table Column Calendar Calendar Calendar Calendar Calendar Calendar Calendar Calendar C_dateid_surrogate C_date C_year C_quarter C_month C_day Calendar_date Calendar_day Integer Date Smallint Char(50) Varchar(100) Smallint Date Char(10) Sales Sales Sales Sales Sales Sales Sales Calendar Calendar Calendar Calendar Calendar Calendar Calendar C_date C_year C_quarter C_month C_day Int Small Datetime Smallint Varchar(50) Varchar(50) Tinyint