How can you quickly and easily build data marts, data warehouses, and operational data stores? With iWay's ETL (Extract, Transform, Load) Manager, you can extract and stage disparate data types across multiple platforms, while applying business rules to transform and cleanse data to load data warehouses – all without having to write COBOL, SQL, or native language routines. ETL Manager provides both a time and event-based scheduler, while providing a full audit trail of each copy request.

You Will Learn How To:

	Understand how ETL Manager interfaces with iWay
	Use the Catalog Administrator to create synonyms and catalogue Remote Procedure Calls (RPCs)
	Use ETL Manager request builder to build copy requests
	Identify the source databases, create joins between databases, and select input fields
	Perform grouping, sorting, and aggregation on input fields
	Assign selection criteria
	Select the target database type, assign keys, transform fields, and apply business rules to selected data
	Schedule the request to run on a time-based schedule
	Assign dependencies to run requests on an event-based schedule
	Invoke exits for external procedures
	Review and manage the audit trail log files
	Organize copy requests by both user ID and request category
	Create quick copy requests for prototyping and initial loads of data warehouses
	Create custom copies for updating data warehouses

Who Should Take This Course:
Developers and administrators who are responsible for creating and maintaining data warehouses, data marts, and operational data stores.

Prerequisite:
Course 910