Datasheet

Chapter 1: SSIS Solution Architecture
16
Table 1 - 2 provides some details for element tracking.
Table 1-1
Item Description
Table or filename This names the file or table and any ongoing naming
conventions (such as name variations if different
systems are involved, or if files have timestamps
included).
Source and definition Describes the source system where the data originates,
and general data that the file contains.
Number of initial records and size If the solution includes an initial data load, this
represents the number of records that are included in
the initial data, and the size of the file or table.
Number of incremental records and size For ongoing data loads, this describes how many
records are involved in the incremental source data, and
the size of the incremental file or table.
Entity usage How the source table or file is used in the solution.
Table 1-2
Item Description
Source table or file The table of the file that the element is sourced from.
Source column or field Name of the table column of field from the file.
Definition Describes the usage of the element in the source.
Data profile analysis An analysis of the data profile — completeness, value variations,
dependencies on other elements, key usage, or uniqueness.
Element usage Lists the destination tables and columns that this source element is
used in, which will be important to keep up-to-date.
Destination Data Dictionary, Usage, and Mapping
Tracking the destination elements so that you can use them to understand what the elements are for,
where they came from, and how they are used is also important.
The destination dictionary describes the elements, but also describes the mapping from the source. This
is invaluable in the ETL process. Again, you should include both an entity mapping and an element
mapping description.
c01.indd 16c01.indd 16 9/24/09 11:26:35 AM9/24/09 11:26:35 AM