Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the Process of ETL (Extract, Transform, Load).
- 1 Answers
- 2069 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 are stored-procedures? And what are the advantages of using them.
What is cursor and where do you use them?
What are the features of a database management system?
How rdbms is different from dbms?
Explain atomicity and aggregation?
What is database management used for?
What is correlated subquery in dbms?
what is the difference between two and three-tier architectures?
can Constraints cannot be exported through EXPORT command ?
2 Answers Grasim, Oracle, Suvidha,
In which format data is stored in database?
What is dba stand for?
What is the use of SHOW option in IMP command ?
-
Oracle (3253) - 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)
