From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 24,800 courses taught by industry experts.
Exploring source data - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Exploring source data
In this section, I'd like to talk about exploring a data source. When we have a new data source, we need to integrate into our ETL solution. There is some questions we'll have about that data. What data types are being used? How often is a column null? How often has a column has a very small value or a very large value? SQL server integration services have some tools that can help us explore the data and answer these types of questions. So I'm going to open SQL server data tools and create a new project it would be an integration services project. I will take the default name and default location In the tool box you'll see a data profiling task, that's what I'm interested in. I'll drag that onto the screen. And by double-clicking on it, I'll get some options on configuring it. I'd like to look at the profile request section. First thing I'd like to look at is a column list distribution request, so this will tell me for a particular column of data; how often we have large value, how…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.