Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the Process of ETL (Extract, Transform, Load).
- 1 Answers
- 1962 Views
- I also Faced
- E-Mail Answers
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 |
What is the difference between multiload and fastload interms of performance?
What are the advantages of rdbms?
What are the different types of database keys?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
Should database table names be capitalized?
Explain the use of assign statement in progress database?
Why do I need netlib?
How to write udf s in delphi?
What are 4 types of models?
What is SQL FORMS ?
What is the benefit of database?
Define database lock and its types.
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
