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 is authorization and integrity manager?
What are the disadvantages of file processing systems?
Describe the Process of Feature Engineering using SQL.
What is the difference between SQL and NoSQL databases
What is a functional dependency in the dbms?
What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?
Explain the difference between a primary key and a unique key?
What are the basic components of notification services?
Explain 3nf?
What are different partitioning techniques in database?
Mention how deadlock can be resolved?
How many rows can a database hold?
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)