Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

What is a business key in datawarehouse?

Contents
  1. What is a business key vs primary key?
  2. What are the different keys in data warehouse?
Each dimension table consist of its business key attribute, the one that uniquely identifies a row in the table. The business key is the attribute that is known in the operational system by the business users.


What is a business key vs primary key?

These are two different kinds of keys. The counter is a surrogate key, and the "business key" is a natural key. All tables in a relational database should (not will, just should) have a declared primary key (PK). This key is a column or group of columns that will uniquely identify a row in the table.

What are the different keys in data warehouse?

Types of Keys :Primary Key – Dimension table's every row is identified by a unique value which is generally known as primary key of the table. ... Surrogate Key – ... Foreign Key – ... Alternate key – ... Composite key – ... Candidate key –Types of Keys in Data Warehouse Schema - GeeksforGeeks

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours