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: DimCustomer
|   CustomerKey |   GeographyKey | CustomerAlternateKey   | Title   | FirstName   | MiddleName   | LastName   | NameStyle   | BirthDate               | MaritalStatus   | Suffix   | Gender   | EmailAddress                    |   YearlyIncome |   TotalChildren |   NumberChildrenAtHome | EnglishEducation   | SpanishEducation                   | FrenchEducation   | EnglishOccupation   | SpanishOccupation   | FrenchOccupation   |   HouseOwnerFlag |   NumberCarsOwned | AddressLine1            | AddressLine2   | Phone               | DateFirstPurchase       | CommuteDistance   |
|--------------:|---------------:|:-----------------------|:--------|:------------|:-------------|:-----------|:------------|:------------------------|:----------------|:---------|:---------|:--------------------------------|---------------:|----------------:|-----------------------:|:-------------------|:-----------------------------------|:------------------|:--------------------|:--------------------|:-------------------|-----------------:|------------------:|:------------------------|:---------------|:--------------------|:------------------------|:------------------|
|         11602 |            135 | AW00011602             |         | Larry       |              | Gill       | False       | 1982-10-11 00:00:00.000 | S               |          | M        | larry16@adventure-works.com     |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | Am Gallberg 645         |                | 1 (11) 500 555-0125 | 2013-07-10 00:00:00.000 | 2-5 Miles         |
|         11603 |            244 | AW00011603             |         | Geoffrey    |              | Gonzalez   | False       | 1982-08-06 00:00:00.000 | S               |          | M        | geoffrey16@adventure-works.com  |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | 1538 Golden Meadow      |                | 1 (11) 500 555-0131 | 2012-01-18 00:00:00.000 | 0-1 Miles         |
|         11610 |            269 | AW00011610             |         | Blake       |              | Collins    | False       | 1980-10-20 00:00:00.000 | S               |          | M        | blake47@adventure-works.com     |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | 4519 Lydia Lane         |                | 1 (11) 500 555-0140 | 2012-01-10 00:00:00.000 | 0-1 Miles         |
|         12517 |            133 | AW00012517             |         | Alexa       |              | Watson     | False       | 1983-02-22 00:00:00.000 | S               |          | F        | alexa0@adventure-works.com      |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | Residenz Straße 98      |                | 1 (11) 500 555-0191 | 2013-10-19 00:00:00.000 | 2-5 Miles         |
|         12518 |            161 | AW00012518             |         | Jacquelyn   |              | Dominguez  | False       | 1983-03-27 00:00:00.000 | S               |          | F        | jacquelyn13@adventure-works.com |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | Werftstr 544            |                | 1 (11) 500 555-0134 | 2013-08-01 00:00:00.000 | 2-5 Miles         |
|         12519 |            265 | AW00012519             |         | Casey       |              | Gutierrez  | False       | 1983-06-16 00:00:00.000 | S               |          | M        | casey34@adventure-works.com     |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | 2035 Emmons Canyon Lane |                | 1 (11) 500 555-0115 | 2013-05-11 00:00:00.000 | 0-1 Miles         |
|         12714 |            157 | AW00012714             |         | Colleen     |              | Lu         | False       | 1979-01-14 00:00:00.000 | S               |          | F        | colleen11@adventure-works.com   |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | Hüttenstr 20995         |                | 1 (11) 500 555-0174 | 2013-07-19 00:00:00.000 | 2-5 Miles         |
|         12728 |            131 | AW00012728             |         | Jeremiah    |              | Stewart    | False       | 1984-12-23 00:00:00.000 | S               |          | M        | jeremiah44@adventure-works.com  |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | Alte Landstr 9902       |                | 1 (11) 500 555-0129 | 2013-04-07 00:00:00.000 | 1-2 Miles         |
|         12871 |            233 | AW00012871             |         | Leah        |              | Li         | False       | 1982-04-05 00:00:00.000 | S               |          | F        | leah2@adventure-works.com       |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | 9405 Curletto Dr.       |                | 1 (11) 500 555-0122 | 2013-11-09 00:00:00.000 | 2-5 Miles         |
|         13671 |            173 | AW00013671             |         | Frank       |              | Ramos      | False       | 1979-08-07 00:00:00.000 | S               |          | M        | frank25@adventure-works.com     |          30000 |               0 |                      0 | Partial College    | Estudios universitarios (en curso) | Baccalauréat      | Clerical            | Administrativo      | Employé            |                0 |                 1 | Carlsplatz 43           |                | 1 (11) 500 555-0146 | 2014-01-28 00:00:00.000 | 1-2 Miles         |


Table: DimDate
|   DateKey | FullDateAlternateKey    |   DayNumberOfWeek | EnglishDayNameOfWeek   | SpanishDayNameOfWeek   | FrenchDayNameOfWeek   |   DayNumberOfMonth |   DayNumberOfYear |   WeekNumberOfYear | EnglishMonthName   | SpanishMonthName   | FrenchMonthName   |   MonthNumberOfYear |   CalendarQuarter |   CalendarYear |   CalendarSemester |   FiscalQuarter |   FiscalYear |   FiscalSemester | FullDateAlternateKey (bins)   |
|----------:|:------------------------|------------------:|:-----------------------|:-----------------------|:----------------------|-------------------:|------------------:|-------------------:|:-------------------|:-------------------|:------------------|--------------------:|------------------:|---------------:|-------------------:|----------------:|-------------:|-----------------:|:------------------------------|
|  20100701 | 2010-07-01 00:00:00.000 |                 5 | Thursday               | Jueves                 | Jeudi                 |                  1 |               182 |                 27 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-06-28 09:34:33.600       |
|  20100702 | 2010-07-02 00:00:00.000 |                 6 | Friday                 | Viernes                | Vendredi              |                  2 |               183 |                 27 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-06-28 09:34:33.600       |
|  20100703 | 2010-07-03 00:00:00.000 |                 7 | Saturday               | Sábado                 | Samedi                |                  3 |               184 |                 27 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-02 01:12:00.000       |
|  20100704 | 2010-07-04 00:00:00.000 |                 1 | Sunday                 | Domingo                | Dimanche              |                  4 |               185 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-02 01:12:00.000       |
|  20100705 | 2010-07-05 00:00:00.000 |                 2 | Monday                 | Lunes                  | Lundi                 |                  5 |               186 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-02 01:12:00.000       |
|  20100706 | 2010-07-06 00:00:00.000 |                 3 | Tuesday                | Martes                 | Mardi                 |                  6 |               187 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-05 16:49:26.400       |
|  20100707 | 2010-07-07 00:00:00.000 |                 4 | Wednesday              | Miércoles              | Mercredi              |                  7 |               188 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-05 16:49:26.400       |
|  20100708 | 2010-07-08 00:00:00.000 |                 5 | Thursday               | Jueves                 | Jeudi                 |                  8 |               189 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-05 16:49:26.400       |
|  20100709 | 2010-07-09 00:00:00.000 |                 6 | Friday                 | Viernes                | Vendredi              |                  9 |               190 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-05 16:49:26.400       |
|  20100710 | 2010-07-10 00:00:00.000 |                 7 | Saturday               | Sábado                 | Samedi                |                 10 |               191 |                 28 | July               | Julio              | Juillet           |                   7 |                 3 |           2010 |                  2 |               1 |         2011 |                1 | 2010-07-09 08:26:52.800       |


Table: DimGeography
|   GeographyKey | City          | StateProvinceCode   | StateProvinceName   | CountryRegionCode   | EnglishCountryRegionName   | SpanishCountryRegionName   | FrenchCountryRegionName   |   PostalCode |   SalesTerritoryKey | IpAddressLocator   |
|---------------:|:--------------|:--------------------|:--------------------|:--------------------|:---------------------------|:---------------------------|:--------------------------|-------------:|--------------------:|:-------------------|
|            292 | Alhambra      | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        91801 |                   4 | 192.0.2.39         |
|            293 | Alpine        | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        91901 |                   4 | 192.0.2.40         |
|            294 | Auburn        | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        95603 |                   4 | 192.0.2.41         |
|            295 | Baldwin Park  | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        91706 |                   4 | 192.0.2.42         |
|            296 | Barstow       | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        92311 |                   4 | 192.0.2.43         |
|            297 | Bell Gardens  | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        90201 |                   4 | 192.0.2.44         |
|            298 | Bellflower    | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        90706 |                   4 | 192.0.2.45         |
|            299 | Berkeley      | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        94704 |                   4 | 192.0.2.46         |
|            300 | Beverly Hills | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        90210 |                   4 | 192.0.2.47         |
|            301 | Burbank       | CA                  | California          | US                  | United States              | Estados Unidos             | États-Unis                |        91502 |                   4 | 192.0.2.48         |


Table: DimProduct
|   ProductKey | ProductAlternateKey   | ProductSubcategoryKey   | WeightUnitMeasureCode   | SizeUnitMeasureCode   | EnglishProductName    | SpanishProductName   | FrenchProductName   | StandardCost   | FinishedGoodsFlag   | Color   |   SafetyStockLevel |   ReorderPoint | ListPrice   | Size   | SizeRange   | Weight   |   DaysToManufacture | ProductLine   | DealerPrice   | Class   | Style   | ModelName   | EnglishDescription   | FrenchDescription   | ChineseDescription   | ArabicDescription   | HebrewDescription   | ThaiDescription   | GermanDescription   | JapaneseDescription   | TurkishDescription   | StartDate               | EndDate   | Status   | DimProductSubcategory.ProductSubcategoryKey   | DimProductSubcategory.ProductSubcategoryAlternateKey   | DimProductSubcategory.EnglishProductSubcategoryName   | DimProductSubcategory.SpanishProductSubcategoryName   | DimProductSubcategory.FrenchProductSubcategoryName   | DimProductSubcategory.ProductCategoryKey   |
|-------------:|:----------------------|:------------------------|:------------------------|:----------------------|:----------------------|:---------------------|:--------------------|:---------------|:--------------------|:--------|-------------------:|---------------:|:------------|:-------|:------------|:---------|--------------------:|:--------------|:--------------|:--------|:--------|:------------|:---------------------|:--------------------|:---------------------|:--------------------|:--------------------|:------------------|:--------------------|:----------------------|:---------------------|:------------------------|:----------|:---------|:----------------------------------------------|:-------------------------------------------------------|:------------------------------------------------------|:------------------------------------------------------|:-----------------------------------------------------|:-------------------------------------------|
|            1 | AR-5381               |                         |                         |                       | Adjustable Race       |                      |                     |                | False               | NA      |               1000 |            750 |             |        | NA          |          |                   0 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|            2 | BA-8327               |                         |                         |                       | Bearing Ball          |                      |                     |                | False               | NA      |               1000 |            750 |             |        | NA          |          |                   0 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|            3 | BE-2349               |                         |                         |                       | BB Ball Bearing       |                      |                     |                | False               | NA      |                800 |            600 |             |        | NA          |          |                   1 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|            4 | BE-2908               |                         |                         |                       | Headset Ball Bearings |                      |                     |                | False               | NA      |                800 |            600 |             |        | NA          |          |                   0 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|            5 | BL-2036               |                         |                         |                       | Blade                 |                      |                     |                | False               | NA      |                800 |            600 |             |        | NA          |          |                   1 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|           12 | CR-9981               |                         |                         |                       | Crown Race            |                      |                     |                | False               | NA      |               1000 |            750 |             |        | NA          |          |                   0 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|           13 | CS-2812               |                         |                         |                       | Chain Stays           |                      |                     |                | False               | NA      |               1000 |            750 |             |        | NA          |          |                   1 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|           14 | DC-8732               |                         |                         |                       | Decal 1               |                      |                     |                | False               | NA      |               1000 |            750 |             |        | NA          |          |                   0 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|           15 | DC-9824               |                         |                         |                       | Decal 2               |                      |                     |                | False               | NA      |               1000 |            750 |             |        | NA          |          |                   0 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |
|           16 | DT-2377               |                         |                         |                       | Down Tube             |                      |                     |                | False               | NA      |                800 |            600 |             |        | NA          |          |                   1 |               |               |         |         |             |                      |                     |                      |                     |                     |                   |                     |                       |                      | 2003-07-01 00:00:00.000 |           | Current  |                                               |                                                        |                                                       |                                                       |                                                      |                                            |


Table: DimProductCategory
|   ProductCategoryKey |   ProductCategoryAlternateKey | EnglishProductCategoryName   | SpanishProductCategoryName   | FrenchProductCategoryName   |
|---------------------:|------------------------------:|:-----------------------------|:-----------------------------|:----------------------------|
|                    1 |                             1 | Bikes                        | Bicicleta                    | Vélo                        |
|                    2 |                             2 | Components                   | Componente                   | Composant                   |
|                    3 |                             3 | Clothing                     | Prenda                       | Vêtements                   |
|                    4 |                             4 | Accessories                  | Accesorio                    | Accessoire                  |


Table: FactInternetSales
|   ProductKey |   OrderDateKey |   DueDateKey |   ShipDateKey |   CustomerKey |   PromotionKey |   CurrencyKey |   SalesTerritoryKey | SalesOrderNumber   |   SalesOrderLineNumber |   RevisionNumber |   OrderQuantity |   UnitPrice |   ExtendedAmount |   UnitPriceDiscountPct |   DiscountAmount |   ProductStandardCost |   TotalProductCost |   SalesAmount |   TaxAmt |   Freight | CarrierTrackingNumber   | CustomerPONumber   | OrderDate               | DueDate                 | ShipDate                |
|-------------:|---------------:|-------------:|--------------:|--------------:|---------------:|--------------:|--------------------:|:-------------------|-----------------------:|-----------------:|----------------:|------------:|-----------------:|-----------------------:|-----------------:|----------------------:|-------------------:|--------------:|---------:|----------:|:------------------------|:-------------------|:------------------------|:------------------------|:------------------------|
|          528 |       20130128 |     20130209 |      20130204 |         14870 |              1 |           100 |                   4 | SO51900            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-01-28 00:00:00.000 | 2013-02-09 00:00:00.000 | 2013-02-04 00:00:00.000 |
|          528 |       20130129 |     20130210 |      20130205 |         15319 |              1 |           100 |                   4 | SO51948            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-01-29 00:00:00.000 | 2013-02-10 00:00:00.000 | 2013-02-05 00:00:00.000 |
|          528 |       20130131 |     20130212 |      20130207 |         16384 |              1 |           100 |                   4 | SO52043            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-01-31 00:00:00.000 | 2013-02-12 00:00:00.000 | 2013-02-07 00:00:00.000 |
|          528 |       20130131 |     20130212 |      20130207 |         15476 |              1 |           100 |                   4 | SO52045            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-01-31 00:00:00.000 | 2013-02-12 00:00:00.000 | 2013-02-07 00:00:00.000 |
|          528 |       20130201 |     20130213 |      20130208 |         15861 |              1 |           100 |                   4 | SO52094            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-02-01 00:00:00.000 | 2013-02-13 00:00:00.000 | 2013-02-08 00:00:00.000 |
|          528 |       20130203 |     20130215 |      20130210 |         26017 |              1 |           100 |                   4 | SO52175            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-02-03 00:00:00.000 | 2013-02-15 00:00:00.000 | 2013-02-10 00:00:00.000 |
|          528 |       20130203 |     20130215 |      20130210 |         14761 |              1 |           100 |                   4 | SO52190            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-02-03 00:00:00.000 | 2013-02-15 00:00:00.000 | 2013-02-10 00:00:00.000 |
|          528 |       20130204 |     20130216 |      20130211 |         22038 |              1 |           100 |                   4 | SO52232            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-02-04 00:00:00.000 | 2013-02-16 00:00:00.000 | 2013-02-11 00:00:00.000 |
|          528 |       20130204 |     20130216 |      20130211 |         22163 |              1 |           100 |                   4 | SO52234            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-02-04 00:00:00.000 | 2013-02-16 00:00:00.000 | 2013-02-11 00:00:00.000 |
|          528 |       20130204 |     20130216 |      20130211 |         16018 |              1 |           100 |                   4 | SO52245            |                      1 |                1 |               1 |        4.99 |             4.99 |                      0 |                0 |                1.8663 |             1.8663 |          4.99 |   0.3992 |    0.1248 |                         |                    | 2013-02-04 00:00:00.000 | 2013-02-16 00:00:00.000 | 2013-02-11 00:00:00.000 |


Table: Sales Vs Target
|   Year |   Sales |   Target |
|-------:|--------:|---------:|
|   2001 |    3000 |     2500 |
|   2002 |    5000 |     3500 |
|   2003 |    8000 |     4550 |
|   2004 |   10000 |     5915 |
|   2005 |   11000 |     6000 |
|   2006 |   15000 |     8000 |
|   2007 |   20000 |    12000 |
|   2008 |   25000 |    14000 |
|   2009 |   35000 |    40000 |
|   2010 |   40000 |    50000 |


Table: SalesActualsvsTargets
| Region   |   Actual |   Forecast |   Max |   Min |
|:---------|---------:|-----------:|------:|------:|
| North    |      180 |        200 |   800 |   200 |
| South    |      400 |        500 |   800 |   200 |
| East     |      350 |        300 |   800 |   200 |
| West     |      200 |        400 |   800 |   200 |

 


tables: name: DimCustomer
data: DimCustomer.csv
name: DimDate
data: DimDate.csv
name: DimGeography
data: DimGeography.csv
name: DimProduct
data: DimProduct.csv
name: DimProductCategory
data: DimProductCategory.csv
name: FactInternetSales
data: FactInternetSales.csv
name: Sales Vs Target
data: Sales Vs Target.csv
name: SalesActualsvsTargets
data: SalesActualsvsTargets.csv
label: DimCustomer
GeographyKey
DimGeography
GeographyKey
FactInternetSales
CustomerKey
DimCustomer
CustomerKey
FactInternetSales
ProductKey
DimProduct
ProductKey
FactInternetSales
DueDateKey
DimDate
DateKey
DimProduct
DimProductSubcategory.ProductCategoryKey
DimProductCategory
ProductCategoryKey
output: {
    "joins": [
        {
            "from_table": "DimCustomer",
            "from_column": "GeographyKey",
            "to_table": "DimGeography",
            "to_column": "GeographyKey"
        },
        {
            "from_table": "FactInternetSales",
            "from_column": "CustomerKey",
            "to_table": "DimCustomer",
            "to_column": "CustomerKey"
        },
        {
            "from_table": "FactInternetSales",
            "from_column": "ProductKey",
            "to_table": "DimProduct",
            "to_column": "ProductKey"
        },
        {
            "from_table": "FactInternetSales",
            "from_column": "DueDateKey",
            "to_table": "DimDate",
            "to_column": "DateKey"
        },
        {
            "from_table": "DimProduct",
            "from_column": "DimProductSubcategory.ProductCategoryKey",
            "to_table": "DimProductCategory",
            "to_column": "ProductCategoryKey"
        }
    ]
}