Explain What is ETL process ?How many steps ETL contains explain with example?
Submitted by: AdministratorETL is extraction , transforming , loading process , you will extract data from the source and apply the business role on it then you will load it in the target
the steps are :
1-define the source(create the odbc and the connection to the source DB)
2-define the target (create the odbc and the connection to the target DB)
3-create the mapping ( you will apply the business role here by adding transformations , and define how the data flow will go from the source to the target )
4-create the session (its a set of instruction that run the mapping , )
5-create the work flow (instruction that run the session)
Submitted by: Administrator
the steps are :
1-define the source(create the odbc and the connection to the source DB)
2-define the target (create the odbc and the connection to the target DB)
3-create the mapping ( you will apply the business role here by adding transformations , and define how the data flow will go from the source to the target )
4-create the session (its a set of instruction that run the mapping , )
5-create the work flow (instruction that run the session)
Submitted by: Administrator
Read Online ETL (Extract, transform, load) Job Interview Questions And Answers
Top ETL (Extract, transform, load) Questions
☺ | Explain What is ETL process ?How many steps ETL contains explain with example? |
☺ | How to calculate fact table granularity? |
☺ | Explain What is Full load & Incremental or Refresh load? |
☺ | Explain the difference between etl tool and olap tools? |
☺ | Explain What are the different versions of Informatica? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |