Ask Question

Extraction, Transformation, and Loading (ETL) is an important component of Group of answer choices Creating a star model. Normalizing relational databases. Denormalization. Sourcing data from OLTP sources and cleansing.

+2
Answers (1)
  1. 3 July, 09:53
    0
    Sourcing data from OLTP sources and cleansing

    Explanation:

    ETL (Extraction, Transformation, and Loading) is important part of database and analytics systems. Every database and data file system has data flows, data inputs and data streams since these systems are dynamic and being updated actively.

    Data from outer (remote) source can be extracted using API's, download options or scraping techniques. These are part of the data extraction.

    Extracted data may not be always as expected and needs to be cleaned and processed before being added to the system. Using transformation methods, data is being shaped into a desired format and loaded to the system.

    OLTP (online transaction processing) plays important role in ETL operations.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Extraction, Transformation, and Loading (ETL) is an important component of Group of answer choices Creating a star model. Normalizing ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers