Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Primary Keys, are they a good practice for Fact Tables?
In a data warehouse, is it a good practice for fact tables to have a actually primary key added as a composite of its FK's. As I understand using a PK can slow down the ETL load process and I can use my ETL tool (informatica) to define a logical key when there’s a need to update or insert the...- AMAL77
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
