Skip to content

Commit f45dca3

Browse files
barbkessbarbkess
committed
updates
1 parent 929184b commit f45dca3

11 files changed

Lines changed: 16 additions & 16 deletions

‎docs/samples/TOC.md‎

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -5,8 +5,8 @@
55
## [OLTP - Install and configure](wide-world-importers-oltp-install-configure.md)
66
## [OLTP - SQL Server features](wide-world-importers-oltp-use-of-sql-server-features.md)
77

8-
## [OLAP - Database catalog](wide-world-importers-olap-database-catalog.md)
9-
## [OLAP - Install and configure](wide-world-importers-olap-install-configure.md)
10-
## [OLAP - SQL Server features](wide-world-importers-olap-use-of-sql-server-features.md)
8+
## [DW - Database catalog](wide-world-importers-dw-database-catalog.md)
9+
## [DW - Install and configure](wide-world-importers-dw-install-configure.md)
10+
## [DW- SQL Server features](wide-world-importers-dw-use-of-sql-server-features.md)
1111
## [Generate data](wide-world-importers-generate-data.md)
1212
## [ETL workflow](wide-world-importers-perform-etl.md)

‎docs/samples/media/wide-world-importers/wideworldimporters-etl-workflow.png‎

70.2 KB
Loading

docs/samples/wide-world-importers-olap-database-catalog.md renamed to docs/samples/wide-world-importers-dw-database-catalog.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ robots: noindex,nofollow
1919
ms.workload: "On Demand"
2020
---
2121
# WideWorldImportersDW database catalog
22-
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
22+
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
2323
Explanations for the schemas, tables, and stored procedures in the WideWorldImportersDW database.
2424

2525
The WideWorldImportersDW database is used for data warehousing and analytical processing. The transactional data about sales and purchases is generated in the WideWorldImporters database, and loaded into the WideWorldImportersDW database using a **daily ETL process**.

docs/samples/wide-world-importers-olap-install-configure.md renamed to docs/samples/wide-world-importers-dw-install-configure.md

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -20,11 +20,11 @@ robots: noindex,nofollow
2020
ms.workload: "On Demand"
2121
---
2222
# WideWorldImportersDW Installation and configuration
23-
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
23+
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
2424
Installation and configuration instructions for the WideWorldImportersDW database.
2525

2626
- [SQL Server 2016](https://www.microsoft.com/evalcenter/evaluate-sql-server-2016) (or higher) or [Azure SQL Database](https://azure.microsoft.com/services/sql-database/). To use the Full version of the sample, use SQL Server Evaluation/Developer/Enterprise Edition.
27-
- [SQL Server Management Studio](../../ssms/download-sql-server-management-studio-ssms.md). For the best results use the June 2016 release or later.
27+
- [SQL Server Management Studio](../ssms/download-sql-server-management-studio-ssms.md). For the best results use the June 2016 release or later.
2828

2929
## Download
3030

docs/samples/wide-world-importers-olap-use-of-sql-server-features.md renamed to docs/samples/wide-world-importers-dw-use-of-sql-server-features.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ robots: noindex,nofollow
2020
ms.workload: "Inactive"
2121
---
2222
# WideWorldImportersDW use of SQL Server features and capabilities
23-
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
23+
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
2424
WideWorldImportersDW is designed to showcase many of the key features of SQL Server that are suitable for data warehousing and analytics. The following is a list of SQL Server features and capabilities, and a description of how they are used in WideWorldImportersDW.
2525

2626
## PolyBase

‎docs/samples/wide-world-importers-generate-data.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ robots: noindex,nofollow
1919
ms.workload: "Inactive"
2020
---
2121
# WideWorldImporters data generation
22-
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
22+
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
2323
The released versions of the WideWorldImporters and WideWorldImportersDW databases contains data starting January 1st 2013, up to the day these databases were generated.
2424

2525
If the sample databases are used at a later date, for demonstration or illustration purposes, it may be beneficial to include more recent sample data in the database.

‎docs/samples/wide-world-importers-oltp-database-catalog.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,7 +19,7 @@ robots: noindex,nofollow
1919
ms.workload: "On Demand"
2020
---
2121
# WideWorldImporters database catalog
22-
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
22+
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
2323
The WideWorldImporters database contains all the transaction information and daily data for sales and purchases, as well as sensor data for vehicles and cold rooms.
2424

2525
## Schemas
@@ -178,7 +178,7 @@ These are the procedures used by a client application, such as a Web front-end.
178178

179179
### Integration Schema
180180

181-
The stored procedures in this schema are used by the ETL process. They obtain the data needed from various tables for the timeframe required by the [ETL package](etl-workflow.md).
181+
The stored procedures in this schema are used by the ETL process. They obtain the data needed from various tables for the timeframe required by the [ETL package](wide-world-importers-perform-etl.md).
182182

183183
### DataLoadSimulation Schema
184184

‎docs/samples/wide-world-importers-oltp-install-configure.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -19,13 +19,13 @@ robots: noindex,nofollow
1919
ms.workload: "On Demand"
2020
---
2121
# Installation and configuration
22-
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
22+
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
2323
Wide World Importers OLTP database installation and configuration instructions.
2424

2525
## Prerequisites
2626

2727
- [SQL Server 2016](https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016) (or higher) or [Azure SQL Database](https://azure.microsoft.com/services/sql-database/). For the Full version of the sample, use SQL Server Evaluation/Developer/Enterprise Edition.
28-
- [SQL Server Management Studio](../../ssms/download-sql-server-management-studio-ssms.md). For the best results use the June 2016 release or later.
28+
- [SQL Server Management Studio](../ssms/download-sql-server-management-studio-ssms.md). For the best results use the June 2016 release or later.
2929

3030
## Download
3131

‎docs/samples/wide-world-importers-oltp-use-of-sql-server-features.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -21,7 +21,7 @@ robots: noindex,nofollow
2121
ms.workload: "Inactive"
2222
---
2323
# Use of SQL Server features and capabilities
24-
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
24+
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
2525
WideWorldImporters use of SQL Server features and capabilities in the OLTP database.
2626

2727
WideWorldImporters is designed to showcase many of the key features of SQL Server, including the latest features introduced in SQL Server 2016. The following is a list of SQL Server features and capabilities, and a description of how they are used in WideWorldImporters.

‎docs/samples/wide-world-importers-perform-etl.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -20,7 +20,7 @@ robots: noindex,nofollow
2020
ms.workload: "Inactive"
2121
---
2222
# WideWorldImportersDW ETL workflow
23-
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
23+
[!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)]
2424
The ETL package WWI_Integration is used to migrate data from the WideWorldImporters database to the WideWorldImportersDW database as the data changes. The package is run periodically (most commonly daily).
2525

2626
## Overview
@@ -31,7 +31,7 @@ Dimensions are loaded first, followed by Fact tables. The package can be re-run
3131

3232
The workflow is as follows:
3333

34-
![WideWorldImporters ETL workflow](../../sample/world-wide-importers/media/wideworldimporters-etl-workflow.png)
34+
![WideWorldImporters ETL workflow](media/wideworldimporters-etl-workflow.png)
3535

3636
It starts with an expression task that works out the appropriate cutoff time. This time is the current time less a few minutes. (This is more robust than requesting data right to the current time). It then truncates any milliseconds from the time.
3737

0 commit comments

Comments
 (0)