Re: Ensuring Rifferential Integrity

2023-09-17 Thread Peter J. Holzer
On 2023-09-17 19:24:52 +0200, Anthony Apollis wrote: >  I brought in the Primary/Secondary/Foreign keys because it does not exist in > the Fact/Dimension tables. > > The Fact tables contain 6 million records and the dimension tables are tiny. > Because some columns don't exist in the Fact and

Ensuring Rifferential Integrity

2023-09-17 Thread Anthony Apollis
I brought in the Primary/Secondary/Foreign keys because it does not exist in the Fact/Dimension tables. The Fact tables contain 6 million records and the dimension tables are tiny. Because some columns don't exist in the Fact and Dimension table I can not update the Foreign Keys in the Fact