Mmodarre/AzureDataFactoryHOL

Incorrect SQL Dataset being imported in SmartFoodFoodNutritionELT SCD 1 Instructions

mdrakiburrahman opened this issue · 1 comments

mdrakiburrahman commented

Thank you for this wonderful lab.

I noticed in the instructions for loading up food_nut.csv and nutsDim.csv in 08-ELT_with_Mapping_Dataflows–Practice_excercises you are referencing bringing in [SmartFoodsDw][foodDim] throughout the tutorial:

image

I do understand that the item_id in food_nut.csv corresponds to the sku in foodDim, in this case, perhaps it would be beneficial to specify that the initial foodDim import is for matching, whereas the sink should be foodNutDim?

Whereas there's no mention of importing [SmartFoodsDw][foodNutDim]:
image

Since the content of those two csv's merges together to form foodNutDim.
image

Thanks!

Mmodarre commented

For loading foodNutDim are reading from SmartFoodsDW.FoodDim to lookup the surrogate key of the currently active Food item. In the above screenshot the two stagings are from food_nut and nuts CSV files and the DB is for lookup to foodDim in database.

The sink DB will be added last at the end of the tutorial and is called "DBSink"