Discovery of ETF – ETL

Discovery of ETF - ETL
Discovery of ETF - ETL

General information

Discovery of FME-ETL

Duration 2 days (14h)
Mode Present or distancial
Level Beginner
Basis requiredNone

The objectives of this training are:

  • To acquire the theoretical and technical knowledge necessary for extraction – data processing and loading (ETL: Extract Transform Load)
  • Know the software environment and manipulating data types
  • How to create and standardize data
  • Create a complete project (know or want to go)

Training programme

Theory

  • Definition of an ETL
  • Reader / Writer / Transformer principles
  • Standardization
  • Example of uses in geographic or non-geographic data

Practice

  • Presentation of the environment
  • Adding data and data sources (Reader)
  • Data Transformation (Transformer)
  • Write Data (Writer)
  • Formatting and notes of a project (Workbench)
  • Transforming them customized
  • The parameters of transformation and public parameters