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: Calendar
| Date                    |   Year |   MonthNo | Month   | Quarter   | YearMonth   |   WeekdayNo | Weekday   | scenario   |
|:------------------------|-------:|----------:|:--------|:----------|:------------|------------:|:----------|:-----------|
| 2003-07-01 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           2 | Tue       | PP         |
| 2003-07-02 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           3 | Wed       | PP         |
| 2003-07-03 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           4 | Thu       | PP         |
| 2003-07-04 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           5 | Fri       | PP         |
| 2003-07-05 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           6 | Sat       | PP         |
| 2003-07-06 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           7 | Sun       | PP         |
| 2003-07-07 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           1 | Mon       | PP         |
| 2003-07-08 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           2 | Tue       | PP         |
| 2003-07-09 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           3 | Wed       | PP         |
| 2003-07-10 00:00:00.000 |   2003 |         7 | Jul     | Q3        | 2003-07     |           4 | Thu       | PP         |


Table: DimChannel
|   ChannelKey |   ChannelLabel | ChannelName   | ChannelDescription   |   ETLLoadID | LoadDate                | UpdateDate              |
|-------------:|---------------:|:--------------|:---------------------|------------:|:------------------------|:------------------------|
|            1 |              1 | Store         | Store                |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|            2 |              2 | Online        | Online               |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|            3 |              3 | Catalog       | Catalog              |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|            4 |              4 | Reseller      | Reseller             |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |


Table: DimCurrency
|   CurrencyKey |   CurrencyLabel | CurrencyName   | CurrencyDescription   |   ETLLoadID | LoadDate                | UpdateDate              |
|--------------:|----------------:|:---------------|:----------------------|------------:|:------------------------|:------------------------|
|             1 |               1 | USD            | US Dollar             |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             2 |               2 | AMD            | Armenian Dram         |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             3 |               3 | AUD            | Australian Dollar     |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             4 |               4 | THB            | Thai Baht             |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             5 |               5 | CAD            | Canadian Dollar       |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             6 |               6 | DKK            | Danish Krone          |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             7 |               7 | EUR            | EURO                  |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             8 |               8 | HKD            | Hong Kong Dollar      |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|             9 |               9 | INR            | Indian Rupee          |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |
|            10 |              10 | ROL            | Romanian Leu          |           1 | 2009-07-11 14:43:19.000 | 2009-07-11 14:43:19.000 |


Table: DimDate
| Datekey                 | FullDateLabel   | DateDescription   |   CalendarYear | CalendarYearLabel   |   CalendarHalfYear | CalendarHalfYearLabel   |   CalendarQuarter | CalendarQuarterLabel   |   CalendarMonth | CalendarMonthLabel   |   CalendarWeek | CalendarWeekLabel   |   CalendarDayOfWeek | CalendarDayOfWeekLabel   |   FiscalYear | FiscalYearLabel   |   FiscalHalfYear | FiscalHalfYearLabel   |   FiscalQuarter | FiscalQuarterLabel   |   FiscalMonth | FiscalMonthLabel   | IsWorkDay   |   IsHoliday | HolidayName   | EuropeSeason   | NorthAmericaSeason   | AsiaSeason   |
|:------------------------|:----------------|:------------------|---------------:|:--------------------|-------------------:|:------------------------|------------------:|:-----------------------|----------------:|:---------------------|---------------:|:--------------------|--------------------:|:-------------------------|-------------:|:------------------|-----------------:|:----------------------|----------------:|:---------------------|--------------:|:-------------------|:------------|------------:|:--------------|:---------------|:---------------------|:-------------|
| 2005-07-01 00:00:00.000 | 2005-07-01      | 2005/07/01        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200527 | Week 27             |             2005276 | Friday                   |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-04 00:00:00.000 | 2005-07-04      | 2005/07/04        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200528 | Week 28             |             2005282 | Monday                   |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-05 00:00:00.000 | 2005-07-05      | 2005/07/05        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200528 | Week 28             |             2005283 | Tuesday                  |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-06 00:00:00.000 | 2005-07-06      | 2005/07/06        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200528 | Week 28             |             2005284 | Wednesday                |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-07 00:00:00.000 | 2005-07-07      | 2005/07/07        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200528 | Week 28             |             2005285 | Thursday                 |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-08 00:00:00.000 | 2005-07-08      | 2005/07/08        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200528 | Week 28             |             2005286 | Friday                   |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-11 00:00:00.000 | 2005-07-11      | 2005/07/11        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200529 | Week 29             |             2005292 | Monday                   |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-12 00:00:00.000 | 2005-07-12      | 2005/07/12        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200529 | Week 29             |             2005293 | Tuesday                  |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-13 00:00:00.000 | 2005-07-13      | 2005/07/13        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200529 | Week 29             |             2005294 | Wednesday                |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |
| 2005-07-14 00:00:00.000 | 2005-07-14      | 2005/07/14        |           2005 | Year 2005           |              20052 | H2                      |             20053 | Q3                     |          200507 | July                 |         200529 | Week 29             |             2005295 | Thursday                 |         2005 | FiscalYear 2005   |            20052 | H2                    |           20053 | Q3                   |        200507 | Month 7            | WorkDay     |           0 | None          | Back to School | Back to School       | None         |


Table: DimGeography
|   GeographyKey | GeographyType   | Continent     | CityName      | State         | Country       | Geometry                 |   ETLLoadID | LoadDate                | UpdateDate              |
|---------------:|:----------------|:--------------|:--------------|:--------------|:--------------|:-------------------------|------------:|:------------------------|:------------------------|
|            782 | City            | North America | Albany        | New York      | United States | POINT (-80.0326 40.9983) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            783 | City            | North America | Alexandria    | Virginia      | United States | POINT (-79.1436 38.5309) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            784 | City            | North America | Anchorage     | Alaska        | United States | POINT (-149.628 61.1147) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            785 | City            | North America | Annapolis     | Maryland      | United States | POINT (-76.5427 38.9884) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            786 | City            | North America | Appleton      | Wisconsin     | United States | POINT (-88.4981 44.2772) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            787 | City            | North America | Arlington     | Texas         | United States | POINT (-84.7898 37.2916) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            788 | City            | North America | Atlantic City | New Jersey    | United States | POINT (-74.4341 39.361)  |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            789 | City            | North America | Attleboro     | Massachusetts | United States | POINT (-71.2998 41.9342) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            790 | City            | North America | Aurora        | Colorado      | United States | POINT (-96.9003 40.6425) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |
|            791 | City            | North America | Austin        | Texas         | United States | POINT (-97.7045 30.4302) |           1 | 2009-09-28 20:19:34.760 | 2009-09-28 20:19:34.760 |


Table: DimProduct
|   ProductKey |   ProductLabel | ProductName                                 | ProductDescription                                                            |   ProductSubcategoryKey | Manufacturer         | BrandName            |   ClassID | ClassName   |   StyleID | StyleName      |   ColorID | ColorName   | Size   | SizeRange   | SizeUnitMeasureID   | Weight   | WeightUnitMeasureID   |   UnitOfMeasureID | UnitOfMeasureName   |   StockTypeID | StockTypeName   |   UnitCost |   UnitPrice | AvailableForSaleDate    | StopSaleDate   | Status   | ImageURL   | ProductURL   |   ETLLoadID | LoadDate                | UpdateDate              |
|-------------:|---------------:|:--------------------------------------------|:------------------------------------------------------------------------------|------------------------:|:---------------------|:---------------------|----------:|:------------|----------:|:---------------|----------:|:------------|:-------|:------------|:--------------------|:---------|:----------------------|------------------:|:--------------------|--------------:|:----------------|-----------:|------------:|:------------------------|:---------------|:---------|:-----------|:-------------|------------:|:------------------------|:------------------------|
|          416 |         303001 | Adventure Works Desktop PC2.33 XD233 Silver | 2.33GHz dual processor, 4MB L2 cache, 750GB 7200RPM hard drive                |                      17 | Adventure Works      | Adventure Works      |         3 | Deluxe      |         1 | Product0303001 |         7 | Silver      |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     321.05 |      969    | 2008-12-09 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          417 |         303002 | Adventure Works Desktop PC2.30 MD230 Silver | 2.3GHz dual processor, 4 GB DDR2 SDRAM memories, 19" widescreen LCD monitors  |                      17 | Adventure Works      | Adventure Works      |         2 | Regular     |         1 | Product0303002 |         7 | Silver      |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     275.46 |      599    | 2008-01-08 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          418 |         303003 | Adventure Works Desktop PC1.60 ED160 Silver | 1.60GHz dual processor, 1GB DDR2 memory, 30GB 5400RPM hard drive              |                      17 | Adventure Works      | Adventure Works      |         1 | Economy     |         1 | Product0303003 |         7 | Silver      |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     137.63 |      269.95 | 2005-05-06 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          423 |         303008 | Adventure Works Desktop PC2.30 MD230 Black  | 2.3GHz dual processor, 4 GB DDR2 SDRAM memories, 19" widescreen LCD monitors  |                      17 | Adventure Works      | Adventure Works      |         2 | Regular     |         1 | Product0303008 |         2 | Black       |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     275.46 |      599    | 2008-01-08 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          429 |         303014 | Adventure Works Desktop PC2.30 MD230 Brown  | 2.3GHz dual processor, 4 GB DDR2 SDRAM memories, 19" widescreen LCD monitors  |                      17 | Adventure Works      | Adventure Works      |         2 | Regular     |         1 | Product0303014 |         4 | Brown       |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     275.87 |      599.9  | 2008-01-08 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          431 |         303016 | Adventure Works Desktop PC1.80 ED180 Brown  | 1.80GHz dual processor, 1GB DDR2 memory, 320GB 5400RPM hard drive             |                      17 | Adventure Works      | Adventure Works      |         2 | Regular     |         1 | Product0303016 |         4 | Brown       |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     188.13 |      369    | 2005-01-02 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          434 |         303019 | Adventure Works Desktop PC2.30 MD230 White  | 2.3GHz dual processor, 4 GB DDR2 SDRAM memories, 19" widescreen LCD monitors  |                      17 | Adventure Works      | Adventure Works      |         2 | Regular     |         1 | Product0303019 |         8 | White       |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     275.46 |      599    | 2008-01-08 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          436 |         303021 | Adventure Works Desktop PC1.80 ED180 White  | 1.80GHz dual processor, 1GB DDR2 memory, 320GB 5400RPM hard drive             |                      17 | Adventure Works      | Adventure Works      |         2 | Regular     |         1 | Product0303021 |         8 | White       |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     188.13 |      369    | 2005-01-02 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          438 |         303023 | WWI Desktop PC2.33 X2330 Silver             | 2.33GHz dual processor, 750GB 7200RPM hard drive, 19” widescreen LCD monitors |                      17 | Wide World Importers | Wide World Importers |         3 | Deluxe      |         1 | Product0303023 |         7 | Silver      |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     304.48 |      919    | 2009-03-08 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |
|          441 |         303026 | WWI Desktop PC1.80 E1800 Brown              | 1.80GHz dual processor, 2GB DDR2 memories, 320GB 5400RPM hard drive           |                      17 | Wide World Importers | Wide World Importers |         1 | Economy     |         1 | Product0303026 |         4 | Brown       |        |             |                     |          | pounds                |                 1 | inches              |             1 | High            |     117.21 |      229.9  | 2005-01-02 00:00:00.000 |                | On       |            |              |           1 | 2009-03-31 00:00:00.000 | 2009-03-31 00:00:00.000 |


Table: DimPromotion
|   PromotionKey |   PromotionLabel | PromotionName                          | PromotionDescription                   |   DiscountPercent | PromotionType     | PromotionCategory   | StartDate               | EndDate                 | MinQuantity   | MaxQuantity   |   ETLLoadID | LoadDate                | UpdateDate              |
|---------------:|-----------------:|:---------------------------------------|:---------------------------------------|------------------:|:------------------|:--------------------|:------------------------|:------------------------|:--------------|:--------------|------------:|:------------------------|:------------------------|
|              1 |                1 | No Discount                            | No Discount                            |              0    | No Discount       | No Discount         | 2003-01-01 00:00:00.000 | 2010-12-31 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              2 |                2 | North America Spring Promotion         | North America Spring Promotion         |              0.05 | Seasonal Discount | Store               | 2007-01-01 00:00:00.000 | 2007-03-31 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              3 |                3 | North America Back-to-School Promotion | North America Back-to-School Promotion |              0.1  | Seasonal Discount | Store               | 2007-07-01 00:00:00.000 | 2007-09-30 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              4 |                4 | North America Holiday Promotion        | North America Holiday Promotion        |              0.2  | Seasonal Discount | Store               | 2007-11-01 00:00:00.000 | 2007-12-31 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              5 |                5 | Asian Holiday Promotion                | Asian Holiday Promotion                |              0.15 | Seasonal Discount | Store               | 2007-11-01 00:00:00.000 | 2008-01-31 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              6 |                6 | Asian Spring Promotion                 | Asian Spring Promotion                 |              0.2  | Seasonal Discount | Store               | 2007-02-01 00:00:00.000 | 2007-04-30 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              7 |                7 | Asian Summer Promotion                 | Asian Summer Promotion                 |              0.1  | Seasonal Discount | Store               | 2007-05-01 00:00:00.000 | 2007-06-30 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              8 |                8 | European Spring Promotion              | European Spring Promotion              |              0.07 | Seasonal Discount | Store               | 2007-02-01 00:00:00.000 | 2007-04-30 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|              9 |                9 | European Back-to-Scholl Promotion      | European Back-to-Scholl Promotion      |              0.1  | Seasonal Discount | Store               | 2007-08-01 00:00:00.000 | 2007-09-30 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |
|             10 |               10 | European Holiday Promotion             | European Holiday Promotion             |              0.2  | Seasonal Discount | Store               | 2007-10-01 00:00:00.000 | 2008-01-31 00:00:00.000 |               |               |           1 | 2009-09-01 00:00:00.000 | 2009-09-01 00:00:00.000 |


Table: DimStore
|   StoreKey |   GeographyKey |   StoreManager | StoreType   | StoreName                   | StoreDescription            | Status   | OpenDate                | CloseDate   |   EntityKey |   ZipCode |   ZipCodeExtension | StorePhone   | StoreFax     | AddressLine1                       | AddressLine2                       | CloseReason   |   EmployeeCount |   SellingAreaSize | LastRemodelDate         | GeoLocation               | Geometry                  |   ETLLoadID | LoadDate                | UpdateDate              |   Year |
|-----------:|---------------:|---------------:|:------------|:----------------------------|:----------------------------|:---------|:------------------------|:------------|------------:|----------:|-------------------:|:-------------|:-------------|:-----------------------------------|:-----------------------------------|:--------------|----------------:|------------------:|:------------------------|:--------------------------|:--------------------------|------------:|:------------------------|:------------------------|-------:|
|         15 |            678 |             48 | Store       | Contoso Renton Store        | Contoso Renton Store        | On       | 2004-02-24 00:00:00.000 |             |         649 |     97001 |              97015 | 424-555-0189 | 424-555-0189 | Renton,Citycenter                  | Renton,Citycenter                  |               |              22 |               500 | 2009-06-17 00:00:00.000 | POINT (-122.189 47.4894)  | POINT (-122.189 47.4894)  |           1 | 2009-07-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         17 |            551 |            135 | Store       | Contoso Spokane Store       | Contoso Spokane Store       | On       | 2004-03-26 00:00:00.000 |             |         651 |     97001 |              97017 | 984-555-0185 | 984-555-0185 | Logan Ave  Shopping mall           | Logan Ave  Shopping mall           |               |              25 |               700 | 2009-06-17 00:00:00.000 | POINT (-117.414 47.6566)  | POINT (-117.414 47.6566)  |           1 | 2009-07-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         20 |            824 |             52 | Store       | Contoso Englewood Store     | Contoso Englewood Store     | On       | 2004-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 |               |              33 |               560 | 2009-06-17 00:00:00.000 | POINT (-104.961 39.6541)  | POINT (-104.961 39.6541)  |           1 | 2009-07-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         22 |            571 |             54 | Store       | Contoso Westminster Store   | Contoso Westminster Store   | On       | 2004-12-03 00:00:00.000 |             |         656 |     87001 |              87003 | 925-555-0114 | 925-555-0114 | South Central Shopping mall        | South Central Shopping mall        |               |              22 |               500 | 2009-06-17 00:00:00.000 | POINT (-0.159302 51.5105) | POINT (-0.159302 51.5105) |           1 | 2009-07-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         25 |            839 |             57 | Store       | Contoso Greeley  No.1 Store | Contoso Greeley  No.1 Store | On       | 2004-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  |               |              25 |               700 | 2009-06-17 00:00:00.000 | POINT (-104.696 40.4083)  | POINT (-104.696 40.4083)  |           1 | 2009-07-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         27 |            859 |             59 | Store       | Contoso Lafayette Store     | Contoso Lafayette Store     | On       | 2004-05-18 00:00:00.000 |             |         661 |     87001 |              87008 | 113-555-0173 | 113-555-0173 | Lafayette Downtown                 | Lafayette Downtown                 |               |              19 |               455 | 2009-06-17 00:00:00.000 | POINT (-86.8644 40.4067)  | POINT (-86.8644 40.4067)  |           1 | 2009-07-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         30 |            829 |             62 | Store       | Contoso Fort Collins Store  | Contoso Fort Collins Store  | On       | 2004-08-21 00:00:00.000 |             |         664 |     87001 |              87011 | 656-555-0119 | 656-555-0119 | Old Town West ST                   | Old Town West ST                   |               |              22 |               500 | 2009-06-17 00:00:00.000 | POINT (-105.079 40.5702)  | POINT (-105.079 40.5702)  |           1 | 2009-05-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         32 |            877 |             63 | Store       | Contoso Milliken Store      | Contoso Milliken Store      | On       | 2004-10-23 00:00:00.000 |             |         666 |     87001 |              87013 | 523-555-0175 | 523-555-0175 | Milliken Downtown                  | Milliken Downtown                  |               |              25 |               700 | 2009-06-17 00:00:00.000 | POINT (-104.858 40.3314)  | POINT (-104.858 40.3314)  |           1 | 2009-05-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         35 |            818 |             65 | Store       | Contoso Denver No.2 Store   | Contoso Denver No.2 Store   | On       | 2004-10-03 00:00:00.000 |             |         669 |     87001 |              87016 | 952-555-0178 | 952-555-0178 | West Highland Borden Ave           | West Highland Borden Ave           |               |              19 |               455 | 2009-06-17 00:00:00.000 | POINT (-105.079 39.812)   | POINT (-105.079 39.812)   |           1 | 2009-05-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2004 |
|         37 |            803 |             66 | Store       | Contoso Boulder Store       | Contoso Boulder Store       | On       | 2003-03-28 00:00:00.000 |             |         671 |     87001 |              87018 | 937-555-0137 | 937-555-0137 | Transit Village Broadway           | Transit Village Broadway           |               |              47 |              1125 | 2009-06-17 00:00:00.000 | POINT (-105.279 40.0134)  | POINT (-105.279 40.0134)  |           1 | 2009-05-10 00:00:00.000 | 2009-06-17 00:00:00.000 |   2003 |


Table: FactSales
|   SalesKey | DateKey                 |   channelKey |   StoreKey |   ProductKey |   PromotionKey |   CurrencyKey |   UnitCost |   UnitPrice |   SalesQuantity |   ReturnQuantity |   ReturnAmount |   DiscountQuantity |   DiscountAmount |   TotalCost |   SalesAmount |   ETLLoadID |
|-----------:|:------------------------|-------------:|-----------:|-------------:|---------------:|--------------:|-----------:|------------:|----------------:|-----------------:|---------------:|-------------------:|-----------------:|------------:|--------------:|------------:|
|    1583317 | 2008-08-13 00:00:00.000 |            1 |        279 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1592014 | 2008-04-08 00:00:00.000 |            1 |        183 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1595208 | 2008-10-22 00:00:00.000 |            1 |        127 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1604114 | 2009-06-24 00:00:00.000 |            1 |        141 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1612010 | 2009-10-16 00:00:00.000 |            1 |        114 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1628154 | 2009-06-08 00:00:00.000 |            1 |         57 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1635176 | 2008-05-06 00:00:00.000 |            1 |         79 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1643240 | 2009-06-13 00:00:00.000 |            1 |        246 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1646408 | 2009-06-04 00:00:00.000 |            1 |         34 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |
|    1649457 | 2008-10-28 00:00:00.000 |            1 |        118 |          363 |              1 |             1 |     321.44 |         699 |              10 |                0 |              0 |                  0 |                0 |      3214.4 |          6990 |           1 |

 


tables: name: Calendar
data: Calendar.csv
name: DimChannel
data: DimChannel.csv
name: DimCurrency
data: DimCurrency.csv
name: DimDate
data: DimDate.csv
name: DimGeography
data: DimGeography.csv
name: DimProduct
data: DimProduct.csv
name: DimPromotion
data: DimPromotion.csv
name: DimStore
data: DimStore.csv
name: FactSales
data: FactSales.csv
label: FactSales
channelKey
DimChannel
ChannelKey
FactSales
CurrencyKey
DimCurrency
CurrencyKey
FactSales
DateKey
DimDate
Datekey
FactSales
ProductKey
DimProduct
ProductKey
FactSales
PromotionKey
DimPromotion
PromotionKey
FactSales
StoreKey
DimStore
StoreKey
DimStore
GeographyKey
DimGeography
GeographyKey
output: {
    "joins": [
        {
            "from_table": "FactSales",
            "from_column": "channelKey",
            "to_table": "DimChannel",
            "to_column": "ChannelKey"
        },
        {
            "from_table": "FactSales",
            "from_column": "CurrencyKey",
            "to_table": "DimCurrency",
            "to_column": "CurrencyKey"
        },
        {
            "from_table": "FactSales",
            "from_column": "DateKey",
            "to_table": "DimDate",
            "to_column": "Datekey"
        },
        {
            "from_table": "FactSales",
            "from_column": "ProductKey",
            "to_table": "DimProduct",
            "to_column": "ProductKey"
        },
        {
            "from_table": "FactSales",
            "from_column": "PromotionKey",
            "to_table": "DimPromotion",
            "to_column": "PromotionKey"
        },
        {
            "from_table": "FactSales",
            "from_column": "StoreKey",
            "to_table": "DimStore",
            "to_column": "StoreKey"
        },
        {
            "from_table": "DimStore",
            "from_column": "GeographyKey",
            "to_table": "DimGeography",
            "to_column": "GeographyKey"
        }
    ]
}