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
How to determine who is and change the owner of database?
What is the best free database software?
What are different types of data models?
What are indexes? What are b-trees?
How big is a big database?
What is query in database?
What is a checkpoint in dbms?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
Differentiate table scan from index scan.
What is db flush?
How do you backup a database?
Is a database a file?
Explain top-n analysis in DBMS.
What are the Roles and responsibilities of database administrator?
What do you understand by index hunting?