etl - DWH import with surrogate keys (and SCD) -

I have a data warehouse which uses the internal surrogate key and gradually changes 2 dimensions. I have the clearing The ARP-system has a business key, such as:

In the data warehouse, we want to use the rental keys instead (th Please note: This article prices went changed from $ 500're using $ 1,000 and articles surrogate keys is possible, even only for producers).

If we just use the business key It was not a problem, just compare, update old entries, insert new entries, but what is the best way to do this with surrogate keys?

Obtaining the current ID (0 or -1 still does not exist) from the data warehouse in the clearing, and then compare the entries?

Business in the Data Warehouse Keep the keys, Compare them and update the ID in the data warehouse?

article, when you load while referring to a producer, you have natural in DWH The business key must be stored. From my experience, it is always done.

But you should only store the source unit's business key in the destination unit. Explain to me, the manufacturer's business key should appear only in the manufacturer table in its DWH, and not anywhere else. When you need to refer to the manufacturer in separate tables, such as paragraph, you use the manufacturer's own rental key.

So, you got it in another screenshot.

Then, when you load the paragraph table and you should know that the manufacturer has changed for a particular article, then you first look at the manufacturer's surrogate key based on your business key and Compare key to key with key. Article table is usually done this way.