12 Questions
What is the main purpose of Incremental Load components?
To update a table only when a record is different between target and source
What do Output components do in the data processing workflow?
Perform reverse-ETL and push formatted data to a target service
What is the purpose of 'Data Source Filter' in connector components?
To define criteria for including rows in the load
What property helps users select a Managed OAuth entry for the data source system?
OAuth
What type of properties differ between connector components?
Shared Properties
Where can users find information about available data sources for a connector component?
In the connector's documentation
What is the main task of connectors in Matillion ETL?
Moving data between two different systems
How do Extract components differ from Query components in Matillion ETL?
Extract components structure data in a JSON-like format
Which component in Matillion ETL is responsible for taking properly formatted data and loading it into the target cloud data warehouse table?
Load
What happens to the target table each time a Query component is used in Matillion ETL?
The table is dropped and recreated
Which type of data commonly requires the use of the Extract Nested Data component in Matillion ETL?
Data structured as it appeared in the source
In Matillion ETL, where are connectors typically placed for use?
Orchestration job canvas
Learn about the different types of connector components in Matillion ETL, which are used to transfer data between systems. Understand how connectors are placed on the canvas of an orchestration job and their availability based on Matillion ETL versions.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free