Kudler Dimensional Model Hands-on-Project Essay
Kudler Dimensional Model Hands On Project Erwin Martinez DBM 460 March 14, 2011 Daniel
McDonald Kudler Dimensional Model Hands On Project Kudler is looking for ways to increase sales
and customer satisfaction. To achieve this goal Kudler will use data mining tools to predict future
trends and behaviors to allow them to make proactive, knowledge driven decisions. Kudler s
marketing director has access to information about all of its customers: their age, ethnicity,
demographics, and shopping habits. The starting point will be a data warehouse containing a
combination of internal data tracking all customers contact coupled with external market data ... Show
more content on Helpwriting.net ...
When building a fact table, the final ETL step is converting the natural keys in the new input records
into the correct, contemporary surrogate keys. ETL maintains a special surrogate key lookup table for
each dimension. Tables Customers CusID | Lname | Fname | Address | City | State | Postal_Zone |
Phone_Number | E_Mail | C1 | Martinez | Erwin | 1234 Main St | Oregon ST | | 95123 | 408 891 4574 |
[email protected] | C2 | Smith | John | 2345 Sun St | San Jose | CA | 95130 | 408 234 5678 |
[email protected] | C3 | Lind | Kathy | 3564 Roberts Dr | New Orleans | LA | 54213 | 504 657 8954 |
[email protected] | Stores StoreID | Store_Name | Store_Address | Store_City | Store_State |
Store_Postal_code | Store_Phone | Store_Email | S1 | La Jolla |
... Get more on HelpWriting.net ...