Solved: Which type of table generally contains foreign key...

aashudream · ‎10-30-2021

Lookup Table

Data Tables

Dimension Tables

mwegener · ‎10-30-2021

Data Table -> Fact Table generally contains foreign keys.

The other two should usually have a primary key column so that the values can be uniquely identified.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast

mwegener · ‎10-30-2021

Data Table -> Fact Table generally contains foreign keys.

The other two should usually have a primary key column so that the values can be uniquely identified.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast

Which type of table generally contains foreign keys?