Category: SQL
-
Silver model part II
We was analyzing our tables in bronze layer to clean in silver layer, we saw that we have some problem with the tables staff and staff_schedule because we have different id_staff from staff schedule and staff table, also we have people that exits in staff_schedule and didn’t exist in staff table, in other hand the…
-
Silver model part I
We will continue our example, we will analyze the data of the files , clean and transform the data from bronze schema. we will analyze the tables staff, staff_schedule and services_weekly. staff we will select the role unique values from staff table : we will select the service unique values from staff table : staff_schedule…