Data warehouse with foreign key

by spitfiredd   Last Updated May 16, 2018 14:06 PM

I have data that I extract and from and and a few other sources. and I throw the data in a warehouse. The sam data I just throw away at the end of the month and add in the updated data from's public extracts.

I am not using a foreign key between the fpds and sam data but there is a relationship between them, and I am able to join them based on a certain key in the data. Should I create a FK relationship between the two tables or just continue without one?

There is a one-to-many relationship from sam -> fpds.

Related Questions

How To Manage Random Data Without Repitition?

Updated August 04, 2015 14:02 PM

Problem in storing data for attendance applications

Updated March 06, 2017 14:06 PM

Data Modeling for different roles

Updated January 03, 2018 10:06 AM

Cache file /home/queryxchang/ could not be written