DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
ERP
|
|
Operational Systems
|
|
CRM
|
|
SJT
|
Detailed explanation-1: -Segment. Segment is a SaaS technology that moves data between systems based on events. Companies use Segment to move data into their data warehouses, and also to move data from one application to another, such as from a marketing automation system into Salesforce. This is not strictly an ETL tool.
Detailed explanation-2: -The ETL tools are used to extract the data from different data sources, transform the data, and load it into a data warehouse system.
Detailed explanation-3: -Types of ETL Tools. ETL tools can be grouped into four categories based on their infrastructure and supporting organization or vendor. These categories-enterprise-grade, open-source, cloud-based, and custom ETL tools-are defined below.