ETL

Duration: 1 days (1 day course with workshops)
Audience: System Administrators, Data integration specialists, CCH Tagetik implementation project members
Prerequisites: CCH Tagetik Foundation & Reporting 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 CCH 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. Overview 
3. Definition 
4. Structure (Domain) 
5. Extraction
6. Transformations
7. Loading 
8. Definition and execution (dataprocessing) 
9. Troubleshooting and analysis
10. Utilities Q&A