Source system pre-integration analysis

By magarity kerns, 2005/06/07

Total article views: 165 | Views in the last 30 days: 19

Rate this |

Join the discussion |

Briefcase

Initial analysis of a new source system can be quite time consuming to manually examine tables and columns to determine which even have worthwhile values in the first place. Running this script against the current database will generate useful information for all the columns of all the tables. Details include data types with varchar lengths, row counts, minimum and maximum values, and a count of the nulls and the distincts. It does take a long time to run but my (your) time can be spent more productively doing something else while this examines all the columns. Please see inline comments for additional thoughts.

By magarity kerns, 2005/06/07

Total article views: 165 | Views in the last 30 days: 19

Your response

Rate this |

Join the discussion |

Briefcase

Related tags

Create and Populate Time Dimension

By patilds | Category: Data Warehouse

| 2,409 reads

Table Function For Data Warehouse Time Dimension

By Joel Janke | Category: Data Warehouse

| 358 reads

Drop foreign keys from a database

By Chip Lambert | Category: Data Warehouse

| 239 reads

Generate Add Foreign Keys statements for the table

By patil | Category: Data Warehouse

| 310 reads

Like this? Try these...

Business Analysis: A Guide to Better Business Requirements

By Additional Articles | Category: System Development Life Cycle

(not yet rated) Rate this | 1,749 reads

Implementing Common Reference Data in a Data Warehouse

By Additional Articles | Category: Data Warehousing

(not yet rated) Rate this | 1,691 reads

Advanced Matrix Reporting Techniques

By Additional Articles | Category: Reporting Services

(not yet rated) Rate this | 1,409 reads

Already registered?

Free registration required

To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.

Register

E-mail address:
Password:
Password (confirm):

Subscriptions

We ask you to register on the site and subscribe to our newsletters. Subscribing to our newsletters gets you:

ALL of our content (thousands of articles, scripts, and forum postings)
A daily newsletter (example)
A weekly news round up (example)
The opportunity to ask and answer questions in our forums
A daily Question of the Day to test and help you increase your knowledge of SQL Server.

We ask that you give the newsletter a try for a week. Over 200,000 SQL Server Professionals a day find it entertaining and useful. If not, you are welcome to unsubscribe at anytime.

Steve Jones
Editor, SQLServerCentral.com