Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tag
Data Profiling
Items 1 to 9 of 9
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,057 reads
Table-Column Data Profiler
Profile all of a table's columns using Transact-SQL.
Read more...
By
Todd Owens
2013/01/25
|
Source:
SQLServerCentral.com
|
Category:
code generation
Rating:
|
Discuss
|
Briefcase
|
889 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
2012/06/11
|
Source:
SQLServerCentral.com
|
Category:
code generation
Rating:
|
Discuss
|
Briefcase
|
2,170 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...
By
Ira Whiteside
2010/02/23
|
Source:
SQLServerCentral.com
|
Category:
integration services (ssis)
Rating:
|
Discuss
|
Briefcase
|
2,134 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...
By
Additional Articles
2009/05/28
|
Source:
SQL Server Performance
|
Category:
integration services (ssis)
Rating:
Rate this
|
Briefcase
|
1,680 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,365 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,171 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
|
4,906 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,833 reads
Items 1 to 9 of 9
Tags
integration services (ssis)
(3)
code generation
(2)
data warehousing
(2)
sql server 2008
(2)
t-sql
(2)
address parsing
(1)
common table expression (cte)
(1)
data quality
(1)
derived column
(1)
ftp task
(1)
functional dependency
(1)
metadata driven
(1)
pattern profiling
(1)
regular expression
(1)
script component
(1)
video
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.