Intro To ETL Flashcards
What is ETL
ETL is a process that Extracts, Transforms, and Loads from multiple sources to a data warehouse or other unified data repository
What is Extract
During data extraction raw data is copied or exported from source locations to a staging area
What is Transform?
In the staging area, the raw data undergoes data processing. Here, the data is transformed and consolidated for its intended analytical use case
What is Load?
In this last step, the transformed data is moved from the staging area into a target data warehouse or database
What is API (Application Programming Interface)?
APIs define a set of rules in which you can interact with a particular application
What is an API key?
An API key is a code that is used to identify and authenticate users of an API. But not all API require a key
