Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Data Profiling Rss

   Items 1 to 11 of 11   
 

Kimball ETL (subsystem 1) – Data Profiling via TSQL

This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)  Read more...
By Ira Whiteside 2014/02/12 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 3,596 reads

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL.  Read more...
By Todd Owens 2014/01/28 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 2,052 reads

Data Profiling with T-SQL

Need to understand new data? This article explains why - and how you can profile it efficiently  Read more...
By Adam Aspin 2013/02/25 | Source: SQLServerCentral.com | Category: data profiling
Rating: |  Discuss |   Briefcase | 1,822 reads

Table-Column Data Profiler

Profile all of a table's columns using Transact-SQL.  Read more...
By Todd Owens 2014/01/28 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 2,052 reads

Kimball ETL (subsystem 1) – Data Profiling via TSQL

This script will generate a report providing all normally expected statistics for data Profiling .(ie.. Min, Max, Unique Count, Pattern etc....)  Read more...
By Ira Whiteside 2014/02/12 | Source: SQLServerCentral.com | Category: code generation
Rating: |  Discuss |   Briefcase | 3,596 reads

Dynamically Map Column Data Based on Column Pattern Profiling

Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.   Read more...
Rating: |  Discuss |   Briefcase | 2,378 reads

Using The Data Profiler Task and FTP Task in SQL Server 2008 Integration Services

See how the data preparation tasks within SSIS can be used to retrieve data or to validate the quality of data.  Read more...
Rating:  Rate this |   Briefcase | 1,807 reads

Data Profiling Column Functional Dependency T-SQL

This article demonstrates Data Profiling Functional Dependency  Read more...
By Ira Whiteside 2009/05/20 | Source: SQLServerCentral.com | Category: data profiling
Rating: |  Discuss |   Briefcase | 3,450 reads

New data profiling tools in SQL Server 2008

New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.  Read more...
By Additional Articles 2009/02/06 | Source: SearchSQLServer | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 2,295 reads

Viewing the Data Profiling Task Data - SQL School Video

It can be helpful in ETL operations to know what the distribution of your data is. Brian Knight shows how to use the Data Profiling task in this video.  Read more...
By Brian Knight 2009/01/27 | Source: JumpStartTV | Category: video
Rating: |  Discuss |   Briefcase | 5,035 reads

Data Quality and Data Profiling

David Loshin describes the benefits of the combination of the bottom-up aspects of data profiling with a top-down analysis phase for establishing criteria for data quality management.   Read more...
By Additional Articles 2009/01/01 | Source: B-Eye | Category: data profiling
Rating: (not yet rated)  Rate this |   Briefcase | 1,890 reads
   Items 1 to 11 of 11   
 
Tags
integration services (ssis) (3)    
code generation (2)    
data warehousing (2)    
sql server 2008 (2)    
t-sql (2)    
address parsing (1)    
common table expressions (cte) (1)    
data quality (1)    
derived column (1)    
ftp task (1)    
functional dependency (1)    
metadata driven (1)    
pattern profiling (1)    
regular expressions (1)    
script component (1)    
video (1)