Course curriculum

    1. Disclaimer

    2. 1. Welcome to the ETL training course.

    3. 2. Understanding the principle of Costperform's ETL function.

    4. 3. Understanding the interface.

    5. 4. Download and unzip the training files.

    1. Lesson 1. Read and complete the inputfile by a lookup.

    2. Lesson 2. Aggregate a transaction file to an input file with unique symbols.

    3. Lesson 3. Using filters.

    4. Lesson 4. Fill incomplete records.

    5. Lesson 5. Add and edit a column.

    6. Lesson 6. Map the headers of a file with the correct ones.

    7. Lesson 7. Split and sort.

    1. Lesson 8. Matrix conversion element.

    2. Lesson 9. Edit multiple columns.

    3. Lesson 10. How or split a text value.

    4. Lesson 11. Join datasources.

    5. Lesson 12. Merge datasources.

    6. Lesson 13. Filter unique combinations of column values from a file.

    7. Lesson 14. Validation of records.

    8. Lesson 15. Sophisticated data manipulation using Decision table.

    9. Lesson 16. Combine a lookup, column editor and aggregate in one chain.

    1. Lesson 17. How to use an ETL chain in a task list?

    2. Lesson 18. Using parameters in your chains

    3. Lesson 19. Passing parameters from a task to your chain.

    4. More advanced options but not covered in this training.

About this course

  • Free
  • 25 lessons
  • 0 hours of video content