Datasheet

Chapter 1: SSIS Solution Architecture
17
Table 1 - 3 provides some details for entity tracking.
Table 1-3
Item Description
Table name This is the destination table name, schema, and database that the table
is used in.
Table description Describes the use of the table in the overall entity-relationship diagram
(ERD), and what general records and grain are included in it.
Keys and grain Lists the primary key and any candidate keys in the table, and the data
grain of the table.
Number of initial records This is the count of the number of expected rows in the table.
Yearly record growth Estimates the number of additional rows that will be added to
the table.
Source entity mapping Lists the source tables of files that are involved in the population
of the table.
Table 1 - 4 provides some details for element tracking.
Table 1-4
Item Description
Destination table name The table and schema that the column is in.
Destination column name Name of the table column.
Column description Describes the usage of the column within the source.
Data type description Describes the expected data types and ranges used in the column.
Usage type Describes the type of usage for the column, such as a primary key,
candidate key, foreign key, auditing column, descriptor column,
and so on.
Source mapping Lists the source fields used to populate the column, and describes
the detailed mapping and transformations needed from the source
to the data elements in the column. This is crucial for ETL processing.
c01.indd 17c01.indd 17 9/24/09 11:26:35 AM9/24/09 11:26:35 AM