Data integration and automation of loading processes.
To make decisions based on facts, you need timely and accurate data. Data quality is critical to the success of any analytics project. Extract, transform and load your data automatically from different sources with Jedox Integrator. This course provides a structured entry into data integration.
Duration: 2 Days
COURSE OBJECTIVES
After this course students will be able to retrieve data from various sources and to transform it for different load processes, to build dimensions, to load transactional data into a cube as well as to automate these processes.
TARGET GROUP
This course is directed at those without specialist knowledge in data integration who want to automatically load and maintain a model from a source system using Jedox
THE TRAINING COVERS
- Database and File Connections
- Extracts (Relational, File, Calendar, ConstantTree, CubeSlice)
- Field Transforms (Date, Lookup, text functions)
- Hierarchy Transforms
- Table Transforms (normalize, loops)
- Dimension and Cube Loads
- Standard Jobs
REQUIREMENTS
- Participation in courses 210 and 251 or equivalent knowledge
- Knowledge of building Jedox models (dimensions, elements, attributes, cubes)
- Knowledge how to enter data in a cube
- Understand the difference between relational and multidimensional data management concepts