Business intelligence Question:

Download Job Interview Questions and Answers PDF

What is the purpose of ETL (Extract Transform Load)?

Business intelligence Interview Question
Business intelligence Interview Question

Answer:

ETL (Extract Transform Load) is used to extract data from various sources. Transform the data which means applying business rules and performing data cleaning (the latter being often overlooked that causes issues) and Load the clean data into data warehouse. Sometimes in ETL there is also master data management element so it can extract data, perform transformation and it may use proper tools to perform data cleansing and check business rules. In recent versions of SQL Server (including 2012) we can have Master Data Services (MDS) and Data Qaulity Services (DQS).

Download Business intelligence Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what is the purpose of cubes?What is the purpose of reporting?