Overview of Examples

The following table lists and describes some of the advanced techniques available to you with DataMigrator. Step-by-step instructions are provided for each sample flow. The sample flows include:

Flow

Applies to Topic...

DMSPLIT

Horizontal Partitioning with Multi-Table Load

DMCODE

Using the Decode Function

DMSURRG

Generating a Surrogate Key

DMSURSCD

Generating a Surrogate Key Using Slowly Changing Dimensions

DMSEQ

Mapping to a Sequential File of a Specific Format

DMREUSE

Creating and Using Reusable Transformations

DMRCTYP

Creating a Target File With Multiple RECTYPEs

DMPIVOT

Combining Multiple Sources Rows in a Single Target Row

DMLKUPS

Using Lookups to Create Multi-Table Flows Without Joins

DMDUPLG

Record Logging

DMVAR

Using Variables in Data Flows

DMORDXML

Creating a Data Flow Using a Target Based on a Predefined XML Schema

DMFLORD

Loading a Target Table Using the File Listener

The sample files listed and described in the following table are used in the examples.

Sample File

Description

dmcomp.mas

Sample - Stores

dmhr.mas

Sample - Human Resources

dmhrinp.mas

Sample target - Human Resources Input

dminv.mas

Sample - Inventory

dminva.mas

Sample target - Inventory Analog

dminvd.mas

Sample target - Inventory Digital

dmlocs.mas

Sample target - Plant locations

dmord.mas

Sample - Orders

dmreps.mas

Sample target - Sales Reps

dmrpts.mas

Sample target - Reporting

dmsale.mas

Sample - Sales Reps

dmstart.mas

Sample target - Employee Start records

dmterm.mas

Sample target - Employee Termination records

dmordfl.mas

Sample - Orders (flat file)

dmordf.mas

Sample target - Orders


iWay Software