Question: ALSETMAX COMPANY Observe the three different tables that exist in the ALSETMAX COMPANY and contains the information about customers. Assume all the values in all

ALSETMAX COMPANY Observe the three different tables that exist in the ALSETMAX COMPANY and contains the information about customers. Assume all the values in all tables are correct. All three tables will be used as the source tables for the dimension CUSTOMER in the ALSETMAX COMPANY dimensionally modeled data warehouse ALSETMAX CUSTOMERS Name Gender CustBirtYear 111-11-1111 Ned 222-22-2222 Nelly Female 333-33-3333 Anna 444-44-4444 Ned 1980 1990 1989 1970 Male Female Male A-MAX CUSTOMER TABLE SSN Name Sex YearOfBirth 111-11-1111 Ned 222-22-2222 NellyF 333-33-3333 Ara 555-55-5555 Ana 1980 1990 1989 1970 AM CUSTOMER ZIPCODE INFO 222-22-2222 333-33-3333 444-44-4444 555-55-5555 60611 60655 60601 60611 60655 This scenario will be used for the following questions citing ALSETMAX COMPANY Based on the three source tables, how many columns will the dimension CUSTOMER in the populated star schema for ALSETMAX COMPANY have? (Assume that the dimension uses a surrogate key, but no time stamps, date valid ranges or status indicators. Also, note that some of the columns in the three sources are overlapping.) Select one ?b.7 O c. 8 d. 10
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
