A customer has sales data containing a fact table, Sales and dimension tables, Customer, Item, and Vendor.
After loading the data, the Entity Relationship Diagram (ERD) has a synthetic table containing the fields Name and Address from the Vendor and Customer tables.
How can a developer eliminate the synthetic keys and appropriately link the data?
- qualify all tables
- alias all primary key fields
- left join the Customer data onto the Sales table
- qualify all tables and then unqualify all key fields
Reveal Solution Next Question