Introduction to iWay DataMigrator
Course 975 - 2 Days - CEU 1.2
How can you quickly and easily build data marts, data warehouses, and operational data
stores? With iWay’s DataMigrator, you can extract and stage disparate data types across
multiple platforms, while applying business rules to transform and cleanse data to load
data warehouses.
You Will Learn How To:
- Use the DataMigrator Data Management Console to build data flows
- Perform grouping, sorting, and aggregation on input fields
-
Assign selection criteria
-
Select target database type, assign keys, transform fields, and apply business rules to
selected data
-
Design process flows with the Data Management Console
-
Group numerous data flows into a single process flow
-
Schedule entire process flow or individual data flow components
-
Specify parallel processing for data flows
-
Send e-mails based on success or failure of any component
- Apply concepts to the creation of a star schema warehouse
-
Create metadata for both source and target files
- Use the DataMigrator Server Web Console to configure the DataMigrator environment
-
Generate reports on DataMigrator activity and review log files
Who Should Take This Course:
Developers and administrators who are responsible for creating and maintaining data
warehouses, data marts, and operational data stores.