Dimension & Fact Tables

Surrogate Key ( Use to connect with the fact tables)

- Primary Key
- Unique Key
- Identity Column
- Product key Column

Business Key

- Alternate Key
- Product Alternate Key

E.x Product Number in the DB table (OLTP) transfers in to Product Alternate key in the Dimension Table.

OLTP sends to the Dimension using the Business Key we do the mapping and same time generate the Surrogate Key. This Surrogate key used in the fact table.

 Alternate Key
In OLTP there is more than one alternate key But in Data warehouse there is only one alternate key.