X hits on this document

417 views

0 shares

1 downloads

0 comments

119 / 131

SAS

Knowledge Modules

Type

Knowledge Module

Description

Check

CKM SAS

Checks data integrity against constraints defined on a SAS table. Rejects invalid records in the error table created dynamically. Can be used for static controls as well as flow controls.

Consider using this KM if you plan to check data integrity on a SAS tables.

This CKM is dedicated to SAS.

Integrate

IKM SAS Control Append

Integrates data in a SAS target table in replace/append mode. When flow data needs to be checked using a CKM, this IKM creates a temporary staging table before invoking the CKM.

Consider using this IKM if you plan to load your SAS target table in replace mode, with or without data integrity check.

To use this IKM, the staging area must be on the same data server as the target.

Integrate

IKM SAS Incremental Update

Integrates data in a SAS target table in incremental update mode. This IKM creates a temporary staging table to stage the data flow. It then compares its content to the target table to guess which records should be inserted and which others should be updated. It also allows performing data integrity check by invoking the CKM.

Inserts and updates are done in bulk set-based processing to maximize performance.

Consider using this IKM if you plan to load your SAS target table to insert missing records and to update existing ones.

To use this IKM, the staging area must be on the same data server as the target.

Load

LKM File to SAS

Loads data from a File to a SAS staging area database.

Consider using this LKM if your source is a flat file and your staging area is a SAS server.

Load

LKM SAS to SQL

Loads data from a SAS source to any Generic SQL staging area. This LKM is similar to the standard “LKM SQL to SQL” described in section “Generic SQL” except that it is dedicated to SAS as source.

Load

LKM SQL to SAS

Loads data from any Generic SQL source database to a SAS staging area. This LKM is similar to the standard “LKM SQL to SQL” described in section “Generic SQL” except

Knowledge Modules Reference Guide

119/131

Document info
Document views417
Page views420
Page last viewedSat Dec 10 03:03:03 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments