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 Pre-defined XML Schema
DMFLORD	Loading a Target Table in Real Time

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

	WebFOCUS