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....)
2014-02-12 (first published: 2012-05-21)
4,161 reads
Ira Whiteside
Advanced SSIS Fuzzy Matching via Record Linkage Methodology
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
2012-07-05
7,993 reads
Master Data Services - SSIS MDM Load
The article will provide an overview of Master Data Services and a sample SSIS Package.
2010-03-02
10,296 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.
2010-02-23
3,390 reads
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
2009-06-10
45,558 reads
Providing Operational Analytics via Microsoft Analysis Services, Infor
This article will review the processes for providing Operational Analytics via Microsoft Analysis Services, Informatica and Qlikview
2009-06-03
2,017 reads
Data Profiling Column Functional Dependency T-SQL
This article demonstrates Data Profiling Functional Dependency
2009-05-20
4,586 reads
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
2009-03-04
11,407 reads
Extending SSIS Part 2 - SSIS Programmatically / Dynamically Building Packages
We bring you part 2 of a series on SSIS programming from Ira Whiteside and Actuality Business Intelligence. This article shows you how to dynamically build a package using code.
2008-10-10
18,591 reads
Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component
In part one of this series from Actuality Business Intelligence, Ira Whiteside brings us a look at building your own SSIS transformation.
2008-07-30
17,408 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Helping an English Student with R
Comments posted to this topic are about the item Helping an English Student with...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers