Describe the Process of ETL (Extract, Transform, Load).
Answer Posted / hr@tgksolutions.com
The process of moving data into a data warehouse from multiple sources is called ETL:
Extract: Gathering information from many source systems.
Transforming the extracted data into a structure or format that is appropriate for analysis and querying is known as transformation. This could entail making sure the data is consistent, eliminating duplicates, and cleansing the data.
Loading: Putting the converted data into the database or data warehouse of choice.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is different keys in dbms?
What is a degree of relation?
Is sql is a dbms?
What is cardinality in db?
Is dynamodb a document database?
What are the different technologies used to access Database from Visual Basic?
What are the integrity rules in dbms?
What are some disadvantages of a standard language such as sql?
What are the benefits of database?
What is the advantage of using preparedstatement?
What is actional flow mapping?
What are the components of rdbms?
What is data sparsity and how it effect on aggregation?
What are the properties of a database?
Define identity and uniqueidentifier property of column?