Comments (2)
Thanks. This is a bug in the Integration procedure. We’ll get this fixed.
From: Jason Farrar [mailto:[email protected]]
Sent: Monday, November 14, 2016 3:16 AM
To: Microsoft/sql-server-samples [email protected]
Subject: [Microsoft/sql-server-samples] Unknown Customers in DW due to NULL BuyingGroupID in WideWorldImporters.Sales.Customers (#154)
I've generated data in the WideWorldImporters database and run the SSIS package to populate the DW database. When I do this I get a large number of transactions with Unknown customers.
The reason appears to be that there are only two buying groups defined in the source database (Tailspin Toys and Wingtip Toys) and the rest of the customers have NULL for their BuyingGroupID. It looks as though this is acceptable, as not all customers would be part of a buying group, but the [Integration].[GetCustomerUpdates] procedure INNER JOIN's on to the BuyingGroups table. Due to this INNER JOIN, I'm only getting customer records in the DW database for Tailspin & Wingtip customers.
I've tried changing the INNER JOIN's in the [Integration].[GetCustomerUpdates] procedure, but this then breaks integrity constaints in the DW database so the customers won't load.
It may be that all customers should have a default BuyingGroup and something has gone wrong during my initial population of data, but I've checked through the scripts and it doesn't look like it.
Can anyone help?
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHubhttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Fissues%2F154&data=02%7C01%7Cjodebrui%40microsoft.com%7Cca89eab1973b4293c5c908d40c7fac56%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636147189864947121&sdata=e8eLGJkPNL8iFJJwhhZ9iRKFqM1P8qUNMatJkz1fCyY%3D&reserved=0, or mute the threadhttps://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAMuA9i71CpufZYuz5UbBOpMhJpUw38i0ks5q-EMIgaJpZM4KxNSp&data=02%7C01%7Cjodebrui%40microsoft.com%7Cca89eab1973b4293c5c908d40c7fac56%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636147189864947121&sdata=toDuimup4rFr%2BmDgvk76lg04mFmVNlsfpFXrsHwMpFQ%3D&reserved=0.
from sql-server-samples.
Apologies for the delayed response. The issue was fixed, but I neglected to close the issue.
The fix is checked in, and will be included in the next release of the sample DB.
from sql-server-samples.
Related Issues (20)
- Sql sample files in blob storage unavailable
- Unable to connect to Azure SQL Server from custom edge module.
- instnwnd.sql is not working exactly HOT 1
- Probe IndexStatistics failed to obtain data: Execution Timeout
- Calling Http endpoints in T-SQL using CURL extension - Content Type. HOT 1
- Sql
- Sebas
- Please update Security Permissions Posters and Post to Newer Blog Site
- create database SQL HOT 2
- .
- Incomplete samples/databases/wide-world-importers/wwi-ssdt/wwi-ssdt/PostDeploymentScripts/pds150-ins-app-cities-h.sql script
- Create Database
- install SQL server connect Database engine HOT 1
- Sql
- SqlEngineConfigAction_install_confignonrc_Cpu64 on Windows 11 HOT 1
- Just to mention ....
- Invoke-SqlAssessment - IndexFragmentation rule doesn't take partitions into consideration HOT 2
- Unpicked sales in WorldWideImporters database causes purchases to increase indefinitely?
- Importing AdventureWorks script does not work on fresh install of SSMS 19 HOT 1
- Data generation fails due to invalid records in ColdRoomTemperatures
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-server-samples.