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 built_in Subprogram ?
What is the structure of a table in database?
How to create a database from my program?
What is delimiter in dbms?
Explain dml (data manipulation language)?
What are the various kinds of interactions catered by dbms?
Compare non-clustered and clustered index
What is the main purpose of triggers in database?
does pl/sql support “overloading”? Explain
Define database.
What is a candidate key in dbms?
Which software is best for database?
What is the 3-tier architecture?
What is the Structural difference between bitmap and b-tree index ?
Explain the difference between primary and foreign key?