Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: DimGeography
|   GeographySK |   GeographyKey | GeographyType   | ContinentName   | ContinentCode   | Country       | Country_name   | RegionCountryName   |   ISO_3166_numeric | ISO_3166_alpha_2   | ISO_3166_alpha_3   | Region        | Subdiv_name   | ISO_3166_2_subdiv   | Subdiv_code   | StateProvinceName   | StateProvinceCode   | City          | CityName      |   Latitude |   Longitude |   Latitude_Geometry |   Longitude_Geometry |   SOR_ID | SOR_LoadDate            | SOR_UpdateDate          | DI_Job_ID   | DI_Create_Date          | DI_Modified_Date        |
|--------------:|---------------:|:----------------|:----------------|:----------------|:--------------|:---------------|:--------------------|-------------------:|:-------------------|:-------------------|:--------------|:--------------|:--------------------|:--------------|:--------------------|:--------------------|:--------------|:--------------|-----------:|------------:|--------------------:|---------------------:|---------:|:------------------------|:------------------------|:------------|:------------------------|:------------------------|
|           782 |            782 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | New York      | New York      | US-NY               | NY            | New York            | AL                  | Albany        | Albany        |    40.9983 |    -80.0326 |             42.6526 |             -73.7562 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           783 |            783 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Virginia      | Virginia      | US-VA               | VA            | Virginia            | AL                  | Alexandria    | Alexandria    |    38.5309 |    -79.1436 |             38.8048 |             -77.0469 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           784 |            784 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Alaska        | Alaska        | US-AK               | AK            | Alaska              | AL                  | Anchorage     | Anchorage     |    61.1147 |   -149.628  |             61.2181 |            -149.9    |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           785 |            785 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Maryland      | Maryland      | US-MD               | MD            | Maryland            | AL                  | Annapolis     | Annapolis     |    38.9884 |    -76.5427 |             38.9784 |             -76.4922 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           786 |            786 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Wisconsin     | Wisconsin     | US-WI               | WI            | Wisconsin           | AL                  | Appleton      | Appleton      |    44.2772 |    -88.4981 |             44.2619 |             -88.4154 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           787 |            787 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Texas         | Texas         | US-TX               | TX            | Texas               | AL                  | Arlington     | Arlington     |    37.2916 |    -84.7898 |             32.7357 |             -97.1081 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           788 |            788 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | New Jersey    | New Jersey    | US-NJ               | NJ            | New Jersey          | AL                  | Atlantic City | Atlantic City |    39.361  |    -74.4341 |             39.3643 |             -74.4229 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           789 |            789 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Massachusetts | Massachusetts | US-MA               | MA            | Massachusetts       | AL                  | Attleboro     | Attleboro     |    41.9342 |    -71.2998 |             41.9445 |             -71.2856 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           790 |            790 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Colorado      | Colorado      | US-CO               | CO            | Colorado            | AL                  | Aurora        | Aurora        |    40.6425 |    -96.9003 |             39.7294 |            -104.832  |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |
|           791 |            791 | City            | North America   | NA              | United States | United States  | United States       |                840 | US                 | USA                | Texas         | Texas         | US-TX               | TX            | Texas               | AL                  | Austin        | Austin        |    30.4302 |    -97.7045 |             30.2672 |             -97.7431 |      123 | 2014-09-28 20:19:34.760 | 2014-09-28 20:19:34.760 | Z5ujd1      | 2017-04-18 17:05:52.803 | 2017-04-18 17:05:52.803 |


Table: DimProduct
|   ProductSK |   ProductKey |   Product_ID | Brand_ID     |   ProductLabel | ProductName                      | ProductDescription                                                                  |   ProductSubcategoryKey |   ProductSubcategoryLabel | ProductSubcategoryName   | ProductSubcategoryDescription   |   ProductCategoryKey |   ProductCategoryLabel | ProductCategoryName   | ProductCategoryDescription   | Manufacturer   | BrandName   |   ClassID | ClassName   |   StyleID | StyleName      |   ColorID | ColorName   | ProductSize   | SizeRange   | SizeUnitMeasureID   |   Weight | WeightUnitMeasureID   |   UnitOfMeasureID | UnitOfMeasureName   |   StockTypeID | StockTypeName   | AvailableForSaleDate    | StopSaleDate   | Status   |   SOR_ID | SOR_LoadDate            | SOR_UpdateDate          | DI_Job_ID   | DI_Create_Date          | DI_Modified_Date        |
|------------:|-------------:|-------------:|:-------------|---------------:|:---------------------------------|:------------------------------------------------------------------------------------|------------------------:|--------------------------:|:-------------------------|:--------------------------------|---------------------:|-----------------------:|:----------------------|:-----------------------------|:---------------|:------------|----------:|:------------|----------:|:---------------|----------:|:------------|:--------------|:------------|:--------------------|---------:|:----------------------|------------------:|:--------------------|--------------:|:----------------|:------------------------|:---------------|:---------|---------:|:------------------------|:------------------------|:------------|:------------------------|:------------------------|
|         339 |          339 | 303010301002 | fabrk0000141 |         301002 | Fabrikam Laptop17W M7080 Black   | 320 GB hard drive, 4 GB RAM 17-inches widescreen LCD with perfect 16:9 aspect ratio |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301002 |         2 | Black       |               |             |                     |      2.8 | pounds                |                 1 | inches              |             1 | High            | 2012-01-04 00:00:00.000 |                | On       |      123 | 2014-01-02 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         340 |          340 | 303010301003 | fabrk0000142 |         301003 | Fabrikam Laptop17 M7000 Black    | 320 GB hard drive, 2 GB RAM 17-inches screens LCD                                   |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301003 |         2 | Black       |               |             |                     |      5.5 | pounds                |                 1 | inches              |             1 | High            | 2012-01-04 00:00:00.000 |                | On       |      123 | 2012-01-04 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         341 |          341 | 303010301004 | fabrk0000143 |         301004 | Fabrikam Laptop16W M6080 Black   | 320 GB hard drive, 2 GB RAM 16-inches widescreen LCD                                |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301004 |         2 | Black       |               |             |                     |      2.2 | pounds                |                 1 | inches              |             1 | High            | 2010-01-05 00:00:00.000 |                | On       |      123 | 2010-01-05 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         343 |          343 | 303010301006 | fabrk0000145 |         301006 | Fabrikam Laptop19 M9000 Black    | 320 GB hard drive, 4 GB RAM 19-inches screen LCD                                    |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301006 |         2 | Black       |               |             |                     |      3.2 | pounds                |                 1 | inches              |             1 | High            | 2010-02-09 00:00:00.000 |                | On       |      123 | 2010-02-09 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         344 |          344 | 303010301007 | fabrk0000146 |         301007 | Fabrikam Laptop12 M2000 White    | 60GB hard drive, 512MB memory                                                       |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301007 |         8 | White       |               |             |                     |      6.5 | pounds                |                 1 | inches              |             1 | High            | 2011-02-08 00:00:00.000 |                | On       |      123 | 2011-02-08 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         345 |          345 | 303010301008 | fabrk0000147 |         301008 | Fabrikam Laptop15 M5000 White    | 15-inches screen, 60 GB hard drive, 128 MB of RAM (512 MB maximum), DVD-ROM         |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301008 |         8 | White       |               |             |                     |      3.8 | pounds                |                 1 | inches              |             1 | High            | 2010-01-04 00:00:00.000 |                | On       |      123 | 2010-01-04 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         347 |          347 | 303010301010 | fabrk0000149 |         301010 | Fabrikam Laptop14.1 M4100 White  | Multimedia-focused laptop with 14.1-inches screen, 320 GB hard drive                |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301010 |         8 | White       |               |             |                     |      6   | pounds                |                 1 | inches              |             1 | High            | 2010-03-08 00:00:00.000 |                | On       |      123 | 2010-03-08 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         348 |          348 | 303010301011 | fabrk0000150 |         301011 | Fabrikam Laptop15.4W M5480 White | 15.4-Inches widescreen TFT LCD display, 1280x800 resolutions                        |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301011 |         8 | White       |               |             |                     |      5.5 | pounds                |                 1 | inches              |             1 | High            | 2010-02-03 00:00:00.000 |                | On       |      123 | 2010-02-03 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         350 |          350 | 303010301013 | fabrk0000152 |         301013 | Fabrikam Laptop12W M2080 Silver  | 60GB hard drive, 1GB memory                                                         |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         2 | Regular     |         1 | Product0301013 |         7 | Silver      |               |             |                     |      5.4 | pounds                |                 1 | inches              |             1 | High            | 2012-01-05 00:00:00.000 |                | On       |      123 | 2012-08-09 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |
|         351 |          351 | 303010301014 | fabrk0000153 |         301014 | Fabrikam Laptop8.9W E0880 Silver | 80GB hard drive (2.2 pounds), 1.6GHz CPU                                            |                      15 |                       301 | Laptops                  | Laptops                         |                    3 |                      3 | Computers             | Computers                    | Fabrikam, Inc. | Fabrikam    |         1 | Economy     |         1 | Product0301014 |         7 | Silver      |               |             |                     |      5.5 | pounds                |                 1 | inches              |             1 | High            | 2012-01-01 00:00:00.000 |                | On       |      123 | 2013-02-09 00:00:00.000 | 2016-12-03 16:35:54.110 | Z5ujd1      | 2017-04-18 17:05:53.083 | 2017-04-18 17:05:53.083 |


Table: DimPromotion
|   PromotionSK |   PromotionID |   PromotionKey |   PromotionLabel | PromotionName                          | PromotionDescription                   |   DiscountPercent | PromotionType     | PromotionCategory   | StartDate               | EndDate                 | MinQuantity   | MaxQuantity   |   SOR_ID | SOR_LoadDate            | SOR_UpdateDate          | DI_Job_ID   | DI_Create_Date          | DI_Modified_Date        |
|--------------:|--------------:|---------------:|-----------------:|:---------------------------------------|:---------------------------------------|------------------:|:------------------|:--------------------|:------------------------|:------------------------|:--------------|:--------------|---------:|:------------------------|:------------------------|:------------|:------------------------|:------------------------|
|             1 |             1 |              1 |                1 | No Discount                            | No Discount                            |              0    | No Discount       | No Discount         | 2008-01-01 00:00:00.000 | 2015-12-31 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             2 |             2 |              2 |                2 | North America Spring Promotion         | North America Spring Promotion         |              0.05 | Seasonal Discount | Store               | 2012-01-01 00:00:00.000 | 2012-03-31 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             3 |             3 |              3 |                3 | North America Back-to-School Promotion | North America Back-to-School Promotion |              0.1  | Seasonal Discount | Store               | 2012-07-01 00:00:00.000 | 2012-09-30 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             4 |             4 |              4 |                4 | North America Holiday Promotion        | North America Holiday Promotion        |              0.2  | Seasonal Discount | Store               | 2012-11-01 00:00:00.000 | 2012-12-31 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             5 |             2 |              5 |                5 | Asian Holiday Promotion                | Asian Holiday Promotion                |              0.15 | Seasonal Discount | Store               | 2012-11-01 00:00:00.000 | 2013-01-31 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             6 |             3 |              6 |                6 | Asian Spring Promotion                 | Asian Spring Promotion                 |              0.2  | Seasonal Discount | Store               | 2012-02-01 00:00:00.000 | 2012-04-30 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             7 |             4 |              7 |                7 | Asian Summer Promotion                 | Asian Summer Promotion                 |              0.1  | Seasonal Discount | Store               | 2012-05-01 00:00:00.000 | 2012-06-30 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             8 |             5 |              8 |                8 | European Spring Promotion              | European Spring Promotion              |              0.07 | Seasonal Discount | Store               | 2012-02-01 00:00:00.000 | 2012-04-30 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|             9 |             6 |              9 |                9 | European Back-to-Scholl Promotion      | European Back-to-Scholl Promotion      |              0.1  | Seasonal Discount | Store               | 2012-08-01 00:00:00.000 | 2012-09-30 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.360 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |
|            10 |             7 |             10 |               10 | European Holiday Promotion             | European Holiday Promotion             |              0.2  | Seasonal Discount | Store               | 2012-10-01 00:00:00.000 | 2013-01-31 00:00:00.000 |               |               |      123 | 2014-09-01 00:00:00.000 | 2016-11-28 10:36:46.363 | Z5ujd1      | 2017-04-18 17:05:52.526 | 2017-04-18 17:05:52.526 |


Table: DimSalesTerritory
|   SalesTerritorySK |   SalesTerritoryKey |   GeographySK |   SalesTerritoryLabel | SalesTerritoryName   | SalesTerritoryRegion   | SalesTerritoryCountry   | SalesTerritoryGroup   |   SalesTerritoryLevel |   SalesTerritoryManager | StartDate               | EndDate   | Status   |   SOR_ID | SOR_LoadDate            | SOR_UpdateDate          | DI_Job_ID   | DI_Create_Date          | DI_Modified_Date        |
|-------------------:|--------------------:|--------------:|----------------------:|:---------------------|:-----------------------|:------------------------|:----------------------|----------------------:|------------------------:|:------------------------|:----------|:---------|---------:|:------------------------|:------------------------|:------------|:------------------------|:------------------------|
|                 43 |                  43 |           835 |              10113007 | Germantown           | Maryland               | United States           | North America         |                     4 |                      77 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 45 |                  45 |           913 |              10113009 | Port Washington      | Wisconsin              | United States           | North America         |                     4 |                      79 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 46 |                  46 |           928 |              10113010 | Sheboygan            | Wisconsin              | United States           | North America         |                     4 |                      80 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 47 |                  47 |           871 |              10113011 | Manitowoc            | Wisconsin              | United States           | North America         |                     4 |                      81 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 48 |                  48 |           870 |              10113012 | Madison              | Wisconsin              | United States           | North America         |                     4 |                      82 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 49 |                  49 |           898 |              10113013 | Oregon               | Wisconsin              | United States           | North America         |                     4 |                      83 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 50 |                  50 |           934 |              10113014 | Stoughton            | Wisconsin              | United States           | North America         |                     4 |                      84 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 51 |                  51 |           822 |              10113015 | Edgerton             | Wisconsin              | United States           | North America         |                     4 |                      85 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 52 |                  52 |           828 |              10113016 | Fort Atkinson        | Wisconsin              | United States           | North America         |                     4 |                      86 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |
|                 53 |                  53 |           918 |              10113017 | Racine               | Wisconsin              | United States           | North America         |                     4 |                      87 | 2014-09-29 00:00:00.000 |           | Current  |      123 | 2014-08-01 00:00:00.000 | 2014-08-01 00:00:00.000 | MZydca      | 2017-04-18 17:12:18.566 | 2017-04-18 17:12:18.566 |


Table: DimStore
|   StoreSK |   StoreID |   StoreKey | SalesTerritorySK   |   StoreManager | StoreType   | StoreName                   | StoreDescription            | Status   | OpenDate                | CloseDate   |   EntityKey |   ZipCode |   ZipCodeExtension | StorePhone   | StoreFax     | AddressLine1                       | AddressLine2                       |   GeographySK | CloseReason   |   EmployeeCount |   SellingAreaSize | LastRemodelDate         |   SOR_ID | SOR_LoadDate            | SOR_UpdateDate          | DI_Job_ID   | DI_Create_Date          | DI_Modified_Date        |
|----------:|----------:|-----------:|:-------------------|---------------:|:------------|:----------------------------|:----------------------------|:---------|:------------------------|:------------|------------:|----------:|-------------------:|:-------------|:-------------|:-----------------------------------|:-----------------------------------|--------------:|:--------------|----------------:|------------------:|:------------------------|---------:|:------------------------|:------------------------|:------------|:------------------------|:------------------------|
|         2 |         2 |          2 |                    |             35 | Store       | Contoso Seattle No.2 Store  | Contoso Seattle No.2 Store  | On       | 2014-02-14 00:00:00.000 |             |         636 |     97001 |              97002 | 150-555-0189 | 150-555-0189 | Mino shopping mall                 | Mino shopping mall                 |           693 |               |              25 |               700 | 2019-06-17 00:00:00.000 |      123 | 2014-06-05 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.363 | 2017-04-18 17:12:18.363 |
|         5 |         5 |          5 |                    |             38 | Store       | Contoso Redmond Store       | Contoso Redmond Store       | On       | 2014-04-02 00:00:00.000 |             |         639 |     97001 |              97005 | 612-555-0100 | 612-555-0100 | Downtown shopping mall             | Downtown shopping mall             |           677 |               |              33 |               560 | 2019-06-17 00:00:00.000 |      123 | 2014-06-13 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.366 | 2017-04-18 17:12:18.366 |
|         7 |         7 |          7 |                    |             40 | Store       | Contoso Granger Store       | Contoso Granger Store       | On       | 2014-06-16 00:00:00.000 |             |         641 |     97001 |              97007 | 913-555-0172 | 913-555-0172 | Granger, WA Downtown shopping mall | Granger, WA Downtown shopping mall |           838 |               |              22 |               500 | 2019-06-17 00:00:00.000 |      123 | 2014-02-11 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.366 | 2017-04-18 17:12:18.366 |
|        10 |        10 |         10 |                    |             43 | Store       | Contoso Wapato Store        | Contoso Wapato Store        | On       | 2014-09-19 00:00:00.000 |             |         644 |     97001 |              97010 | 145-555-0130 | 145-555-0130 | Wapato, Citycenter                 | Wapato, Citycenter                 |           947 |               |              25 |               700 | 2019-06-17 00:00:00.000 |      123 | 2014-02-11 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.366 | 2017-04-18 17:12:18.366 |
|        15 |        15 |         15 |                    |             48 | Store       | Contoso Renton Store        | Contoso Renton Store        | On       | 2014-02-24 00:00:00.000 |             |         649 |     97001 |              97015 | 424-555-0189 | 424-555-0189 | Renton,Citycenter                  | Renton,Citycenter                  |           678 |               |              22 |               500 | 2019-06-17 00:00:00.000 |      123 | 2014-07-10 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.366 | 2017-04-18 17:12:18.366 |
|        17 |        17 |         17 |                    |            135 | Store       | Contoso Spokane Store       | Contoso Spokane Store       | On       | 2014-03-26 00:00:00.000 |             |         651 |     97001 |              97017 | 984-555-0185 | 984-555-0185 | Logan Ave  Shopping mall           | Logan Ave  Shopping mall           |           551 |               |              25 |               700 | 2019-06-17 00:00:00.000 |      123 | 2014-07-10 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.370 | 2017-04-18 17:12:18.370 |
|        20 |        20 |         20 |                    |             52 | Store       | Contoso Englewood Store     | Contoso Englewood Store     | On       | 2014-09-29 00:00:00.000 |             |         654 |     87001 |              87001 | 435-555-0113 | 435-555-0113 | Cherry Hills Village Shopping mall | Cherry Hills Village Shopping mall |           824 |               |              33 |               560 | 2019-06-17 00:00:00.000 |      123 | 2014-07-10 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.370 | 2017-04-18 17:12:18.370 |
|        22 |        22 |         22 |                    |             54 | Store       | Contoso Westminster Store   | Contoso Westminster Store   | On       | 2014-12-03 00:00:00.000 |             |         656 |     87001 |              87003 | 925-555-0114 | 925-555-0114 | South Central Shopping mall        | South Central Shopping mall        |           571 |               |              22 |               500 | 2019-06-17 00:00:00.000 |      123 | 2014-07-10 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.370 | 2017-04-18 17:12:18.370 |
|        25 |        25 |         25 |                    |             57 | Store       | Contoso Greeley  No.1 Store | Contoso Greeley  No.1 Store | On       | 2014-03-16 00:00:00.000 |             |         659 |     80631 |              80631 | 332-555-0150 | 332-555-0150 | W 29th Street, Greeley CityCenter  | W 29th Street, Greeley CityCenter  |           839 |               |              25 |               700 | 2019-06-17 00:00:00.000 |      123 | 2014-07-10 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.370 | 2017-04-18 17:12:18.370 |
|        27 |        27 |         27 |                    |             59 | Store       | Contoso Lafayette Store     | Contoso Lafayette Store     | On       | 2014-05-18 00:00:00.000 |             |         661 |     87001 |              87008 | 113-555-0173 | 113-555-0173 | Lafayette Downtown                 | Lafayette Downtown                 |           859 |               |              19 |               455 | 2019-06-17 00:00:00.000 |      123 | 2014-07-10 00:00:00.000 | 2016-11-28 10:36:39.976 | MZydca      | 2017-04-18 17:12:18.373 | 2017-04-18 17:12:18.373 |


Table: FactSales
|   SalesSK |   SalesDateSK | SalesDate               |   ChannelSK |   StoreSK |   ProductSK |   PromotionSK |   GeographySK |   Sales Quantity |   ReturnQuantity |   Sales Amount |   ReturnAmount |   DiscountAmount |   TotalCost |   Local_CurrencySK |   SalesAmount_Local |   ReturnAmount_Local |   DiscountAmount_Local |   TotalCost_Local |   SOR_ID | SOR_LoadDate            | SOR_UpdateDate          | DI_Job_ID   | DI_Create_Date          | DI_Modified_Date        |
|----------:|--------------:|:------------------------|------------:|----------:|------------:|--------------:|--------------:|-----------------:|-----------------:|---------------:|---------------:|-----------------:|------------:|-------------------:|--------------------:|---------------------:|-----------------------:|------------------:|---------:|:------------------------|:------------------------|:------------|:------------------------|:------------------------|
|    161182 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.833 | 2017-04-18 16:34:19.833 |
|    161263 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.833 | 2017-04-18 16:34:19.833 |
|    161283 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.836 | 2017-04-18 16:34:19.836 |
|    161331 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.836 | 2017-04-18 16:34:19.836 |
|    162342 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.836 | 2017-04-18 16:34:19.836 |
|    162525 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.840 | 2017-04-18 16:34:19.840 |
|    162709 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.840 | 2017-04-18 16:34:19.840 |
|    162812 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.840 | 2017-04-18 16:34:19.840 |
|    163229 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.840 | 2017-04-18 16:34:19.840 |
|    163686 |      20140604 | 2014-06-04 00:00:00.000 |           2 |       199 |        2496 |             1 |           800 |                1 |                0 |          10.39 |              0 |                0 |           1 |                  1 |               10.39 |                    0 |                      0 |              5.24 |      123 | 2014-06-04 00:00:00.000 | 2014-06-04 00:00:00.000 | 1yuNlP      | 2017-04-18 16:34:19.843 | 2017-04-18 16:34:19.843 |

 


tables: name: DimGeography
data: DimGeography.csv
name: DimProduct
data: DimProduct.csv
name: DimPromotion
data: DimPromotion.csv
name: DimSalesTerritory
data: DimSalesTerritory.csv
name: DimStore
data: DimStore.csv
name: FactSales
data: FactSales.csv
label: FactSales
StoreSK
DimStore
StoreSK
FactSales
ProductSK
DimProduct
ProductSK
FactSales
PromotionSK
DimPromotion
PromotionSK
FactSales
GeographySK
DimGeography
GeographySK
DimSalesTerritory
GeographySK
DimGeography
GeographySK
output: {
    "joins": [
        {
            "from_table": "FactSales",
            "from_column": "StoreSK",
            "to_table": "DimStore",
            "to_column": "StoreSK"
        },
        {
            "from_table": "FactSales",
            "from_column": "ProductSK",
            "to_table": "DimProduct",
            "to_column": "ProductSK"
        },
        {
            "from_table": "FactSales",
            "from_column": "PromotionSK",
            "to_table": "DimPromotion",
            "to_column": "PromotionSK"
        },
        {
            "from_table": "FactSales",
            "from_column": "GeographySK",
            "to_table": "DimGeography",
            "to_column": "GeographySK"
        },
        {
            "from_table": "DimSalesTerritory",
            "from_column": "GeographySK",
            "to_table": "DimGeography",
            "to_column": "GeographySK"
        }
    ]
}