Categories: DW & ETL

ETL Tools – What to Learn?

ETL Tools: What to Learn?

With the help of ETL tools, we can create powerful target Data Warehouses without much difficulty. Following are the various options that we have to know and learn in order to use ETL tools.

Software:

How to install ETL tool on server/client?

Working with an ETL Tool:

How to work with various options like designer, mapping, workflow, scheduling etc.,?
How to work with sources like DBMS, relational source databases, files, ERPs etc., and import the source definitions?
How to import data from data modeling tools, applications etc.,?
How to work with targets like DBMS, relational source databases, files, ERPs etc., and import the source definitions?
How to create target definitions?
How to create mappings between source definitions and target definitions?
How to create transformations?
How to cleanse the source data?
How to create a dimension, slowly changing dimensions, cube etc.,?
How to create and monitor workflows?
How to configure, monitor and run debugger?
How to view and generate metadata reports?

learndmdwbi

Next ETL Concepts »

Previous « ETL Tools

View Comments

Sasti Gowtham says:

October 22, 2016 at 4:35 pm

Its very useful site to learn about data modeling and DWH. Would like to get idea about Machine learning. If possible, please send the tutorials.
- Pawan Kumar says:
  
  June 14, 2017 at 10:27 pm
  
  I need etl developer questions and answers please
Ashwitha says:

September 4, 2018 at 8:20 pm

Need Etl testing concepts and interview questions