ETL (Extract, transform, load) Question: Download Questions PDF
Explain What is ETL process ?How many steps ETL contains explain with example?
![Extract, transform, load (ETL) Interview Answer Extract, transform, load (ETL) Interview Question](https://globalguideline.com/public/images/interview/15.png)
Answer:
ETL 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)
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)
Download Extract, transform, load (ETL) Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain What is Informatica Metadata and where is it stored? | How to call shell scripts from informatica? |