Databases Reference
In-Depth Information
cross-reference table
a table that contains only the current rows of a larger dimension table. Columns
generally include all business key columns and a digest column. The business key
column is used to determine if source rows are new dimensions or updates to existing
dimensions. The digest column is used to detect changes in source rows that might
update an existing dimension. During updates of the fact table that is associated
with the dimension table, the cross-reference table can provide generated keys that
replace the business key in new fact table rows.
custom repository
in the SAS Open Metadata Architecture, a metadata repository that must be
dependent on a foundation repository or custom repository, thus allowing access to
metadata definitions in the repository or repositories on which it depends. A custom
repository is used to specify resources that are unique to a particular data collection.
For example, a custom repository could define sources and targets that are unique to
a particular data warehouse. The custom repository would access user definitions,
group definitions, and most server metadata from the foundation repository. See also
foundation repository, project repository.
data analysis
in SAS data quality, the process of evaluating input data sets in order to determine
whether data cleansing is needed.
data cleansing
the process of eliminating inaccuracies, irregularities, and discrepancies from
character data.
data lineage
a search that seeks to identify the tables, columns, and transformations that have an
impact on a selected table or column. See also impact analysis, reverse impact
analysis, transformation.
data transformation
in SAS data quality, a cleansing process that applies a scheme to a specified
character variable. The scheme creates match codes internally to create clusters. All
values in each cluster are then transformed to the standardization value that is
specified in the scheme for each cluster.
database library
a collection of one or more database management system files that are recognized by
SAS and that are referenced and stored as a unit. Each file is a member of the library.
database server
a server that provides relational database services to a client. Oracle, DB/2 and
Teradata are examples of relational databases.
delimiter
a character that separates words or phrases in a text string.
derived mapping
a mapping between a source column and a target column in which the value of the
target column is a function of the value of the source column. For example, if two
tables contain a Price column, the value of the target table's Price column might be
equal to the value of the source table's Price column multiplied by 0.8.
digest column
a column in a cross-reference table that contains a concatenation of encrypted values
for specified columns in a target table. If a source row has a digest value that differs
from the digest value for that dimension, then changes are detected and the source
Search WWH ::
Custom Search