ETL

Duration: 1 day
Audience: Administrators, Data integration specialists and Implementers
Prerequisites: Data Model (mandatory), Output Reporting & Data Collection (recommended) training, SQL programming language, understanding of ETL concept & processes

Objectives: This training covers the basics of the CCH® Tagetik ETL module configuration and provides best practices. The attendees will configure an ETL with mapping functionality that can load financial data for a Tagetik implementation. With this knowledge you can also update existing ETL’s with new functionality according to changes and/or new requirements.

Topics:

1. Introduction
2. ETL Overview 
3. ETL Definition 
4. Structure (ETL Domain) 
5. E-Extraction
6. T-Transformations
7. L-Loading 
8. Definition and execution (data processing) 
9. Troubleshooting and data analysis
10. Utilities