Resolved: Clarification on Merge
reaching out to you and asking some additional clarification with Merge, please.
What is the added benefit(s) of merge vs the option to have two table connected to each other via the CurrencyKey anyway?
Also, once we are done with the merge (e.g. created a Currency name column in the factInternetSales table) shall I consider the deletion of the dimCurrency table or that is still required in order to maintain the newly created column?
A bit confused, hope you can shed a light!
Anyway great content - thanks for that!