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 |
Why are databases so important?
what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000
0 Answers Indian Web Technology,
Is database a data structure?
What is natural key?
What do you mean by starvation in dbms?
What is network database?
What are the importance of database in banking?
What is computer end?
Which database server is best?
What is data redundancy in dbms?
Enlist the cursor types.
What is bcnf in the dbms?
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)