Describe the Process of ETL (Extract, Transform, Load).
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 database should I learn first?
How to retrive a single data from a database
What are records and fields in a database?
What are procedures in database?
Explain the concepts of a primary key and foreign key.
What are the examples of database?
What are the applications of database management system?
how Data is stored in a file so that Direct Searching can be performed
Is excel a database?
Explain the advantages of rdbms?
What do you mean by buffer manager?
What do you understand by fragmentation?
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)