What is ETL process in Data warehousing?

Answer Posted / ramjanaki

ETL Process can be defined as the Extraction of Information
from various sources like flat files, databases or XML
data, Performing transformations (manipulations on the data)
based on the user requirements and loading them to the
Target location.

Is This Answer Correct ?    29 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to improve session performance in aggregator transformation?

621


Explain the data type of the surrogate key?

633


Explain difference between view and materialized view?

598


What is the difference between constraind base load ordering and target load plan?

742


How do we design a universe?

588






Explain what is the data type of the surrogate key?

657


What are universe requirements?

611


What is a data profile?

658


Database in use is oracle?

693


What are diagrams?

709


What is a general purpose scheduling tool?

651


How can you set the session management?

671


What is surrogate key? Where we use it?

643


What is a Decision Tree Algorithm?

4633


What are the main steps to build the data warehouse?

741