Get Help With Your Essay

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

For This or a Similar Paper Click To Order Now

 

**Using pgAdmin4
**Restore backupfile to pgAdmin4
** Request Writer [430444]
In the class exercise we created 3 dimension table for our TB DW: Year, Country and Gender. Though rare, Country Names do change. For example: In 1997 Zaire became Democratic Republic of the Congo. Also, in 2018 Swaziland changed to Eswatini. For this exercise, make believe that happened in 2008
This exercise is to alter the country_dim table to become “Type 2 SCD”. Review page 27 in the Kimball Group Reader to ensure the appropriate fields are added.
Also, please consider 2 digit country codes as ‘Natural Keys’. Here is a list
– https://www.iban.com/country-codes (Links to an external site.).
For now, make sure these are updated for the countries changing (other can be value ‘NA’)
Be sure to change the fact table accordingly.
Your should show the SQL / DDL to create / alter the tables
and show the data and queries showing the varying dimension data.

Get Help With Your Essay

"Place your order now for a similar assignment and have exceptional work written by our team of experts, guaranteeing you A results."

For This or a Similar Paper Click To Order Now