Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
24 Cards in this Set
- Front
- Back
What is the ultimate goal of DATA INTEGRATION? |
Gain Useful and Valuable Information to Help Solve Problems and Gain New Insights |
|
What is ETL? |
Extraction, Transforming, and Loading |
|
Use of ETL? |
Do data analysis |
|
ETL Process: Critical Components |
- Auditing and Logging - Supports change data capture - Handle multiple source format - Fault Tolerance - Notification Support - Low Latency - Scalable - Accurate |
|
The system notifies you when a record has been changed |
Update Notification |
|
System is unable to notify but identifies which record has been notified |
Incremental Extraction |
|
System cannot identify which data has been changed, so it reloads all the data to get data out of system |
Full Extraction |
|
The phase of Cleansing and Aggregation of Data |
Transform Phase |
|
The classic ETL process |
Multistage Data Transformation |
|
Data is loaded into the analytics warehouse and transformation is done there. ELT |
In-warehouse data transformation |
|
What are the two ttransformation Types |
Basic and Advanced Transformation |
|
A phase that depends largely on what you intend to do with the data |
Load Phase |
|
Entire data dump takes place when data is loaded for the first time |
Full load |
|
Target and source data is dumped at regular intervals |
Incremental Data |
|
An incremental load that is better for loading small data volumes |
Streaming Incremental Load |
|
An incremental load better for loading large data volumes |
Batch Incremental Load |
|
What are the three common problem areas in taking Intemental Loads? |
- ordering - schema evolution - monitorability |
|
Types of ETL tools |
- Open-sourced - Batch Processing - Cloud-based - Real-time |
|
An ETL tool that is easy to integrate with other systems |
Open Source ETL tool |
|
Tool that consolidates data when there is less competition for computational power |
Batch Processing |
|
Tool that collects data from any cloud service |
Cloud Bases tool |
|
Tool that can get instant updates on all business activities |
Real time tools |
|
How ETL boost marketing strategy |
- Improve Quality of Data - Boost Insights - Boost Efficiency - Precise Data Analytics |
|
What is the ultimate goal of DATA INTEGRATION? |
Gain Useful and Valuable Information to Help Solve Problems and Gain New Insights |