What is the purpose of ETL process in DW?

 Posted by Bandi on 6/23/2015 | Category: Sql Server Interview questions | Views: 172 | Points: 40
Answer:

Extract Transform and Load is a process in data warehousing that involves:
1. Extracting data from outside/multiple sources
2. Transforming it to fit operational needs (which can include quality levels)
3. Loading it into the end target (database, data mart or data warehouse)


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response