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 table
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 Dime
