Course curriculum
-
1
Introduction to CostPerform's ETL function
-
Disclaimer
-
1. Welcome to the ETL training course.
-
2. Understanding the principle of Costperform's ETL function.
-
3. Understanding the interface.
-
4. Download and unzip the training files.
-
-
2
Simple conversions
-
Lesson 1. Read and complete the inputfile by a lookup.
-
Lesson 2. Aggregate a transaction file to an input file with unique symbols.
-
Lesson 3. Using filters.
-
Lesson 4. Fill incomplete records.
-
Lesson 5. Add and edit a column.
-
Lesson 6. Map the headers of a file with the correct ones.
-
Lesson 7. Split and sort.
-
-
3
Advanced conversions.
-
Lesson 8. Matrix conversion element.
-
Lesson 9. Edit multiple columns.
-
Lesson 10. How or split a text value.
-
Lesson 11. Join datasources.
-
Lesson 12. Merge datasources.
-
Lesson 13. Filter unique combinations of column values from a file.
-
Lesson 14. Validation of records.
-
Lesson 15. Sophisticated data manipulation using Decision table.
-
Lesson 16. Combine a lookup, column editor and aggregate in one chain.
-
-
4
Advanced options with the ETL
-
Lesson 17. How to use an ETL chain in a task list?
-
Lesson 18. Using parameters in your chains
-
Lesson 19. Passing parameters from a task to your chain.
-
More advanced options but not covered in this training.
-