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.
Ilgums: 2 dienas
Mērķis
Pēc šī kursa studenti varēs:
– Build complex time dimensions
– Transform data using the scripting language Groovy
– Connect to web services and load data
Mērķauditorija
This course is directed at those who want to improve the design of data load processes with enhanced ETL functionalities.
Kurss iekļauj
- 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)
Prasības
- 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
- - Vispārēja izpratne par skriptu valodām