I am designing a Dataware house for the Stackoverflow job section. I have two dimensions: job opportunity and company. every record of job opportunity is referenced to only one record of company dimension. there are two ways to implement this relationship.
I doubt which approach is better. can anyone help?