Answer Detail: RE: What is a Key MAP table?

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Print |

Question: What is a Key MAP table?

January 01, 2007 13:34:23	#1
Bhanu	Member Since: Visitor Total Comments: N/A
RE: What is a Key MAP table?
a data warehousing best practice is to create surrogate keys--typically a meaningless simple integer--for the primary key in each dimension table. The associated fact table rows use this same surrogate as a foreign key reference to the dimension tables.