Script-based transformation of complex data structures
Go from Professional to ETL Expert. Expand your skills in Jedox ETL and learn advanced techniques with this course.
Duration: 2 Days
COURSE OBJECTIVES
After this course students will be able to:
– Build complex time dimensions
– Transform data using the scripting language Groovy
– Connect to web services and load data
TARGET GROUP
This course is directed at those who want to improve the design of data load processes with enhanced ETL functionalities.
THE TRAINING COVERS
- Introduction to script-based transformation (Groovy)
- Script-based text operations (Groovy, RegEx)
- Script-based date operations (Groovy)
- Extract XML data (HTTP, SOAP, XPath)
- Loop-based data load (Groovy)
REQUIREMENTS
- Participation in course 356 Integration Professional or
- equivalent knowledge
- To be most successful, students should have some or, at
- best, all of the following background:
- – Ability to create file connections, extracts, transforms, loads
- – Sound knowledge of job execution and adjustment of given objects
- – General understanding of scripting languages