Describe the Process of ETL (Extract, Transform, Load).
Answer Posted / hr@tgksolutions.com
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 |
Post New Answer View All Answers
What are the advantages of rdbms?
What are the types of distributed database?
How do you notify dbpak about stored procedure?
What is openedge workgroup rdbms?
What is second normal form?
Describe the four types of indexes.
What is oracle block?
1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?
Why c++ used in clipper?
What are the characteristics of database management system?
What is unique key in dbms?
Enlist the types of cursor?
Is mysql a rdbms?
Explain a tp monitor?
Mention the different languages present in dbms