can ingest data at scale from common relational databases and propagate the data to multiple types of targets, including cloud-based targets and targets that can handle big data.
Mass Ingestion Databases
is a separately licensed feature of the
Informatica Intelligent Cloud Services
Mass Ingestion
service.
The
Mass Ingestion
service provides an easy-to-use interface for configuring and deploying
database ingestion
tasks and for running and monitoring ingestion jobs. A job is an executable instance of an ingestion task.
Mass Ingestion Databases
can perform the following types of load operations:
Initial load
. Loads source data read at a single point in time to a target. After the data is loaded, the ingestion job ends. You can use this load type to materialize a target to which incremental changes will be sent later, to migrate from an on-premises database system to a cloud-based system, or to add data to a data lake or data warehouse.
Incremental load
. Propagates data changes continuously or until the job is stopped or ends. The job propagates the changes that have occurred since the last time it ran or from a specific start point. You can use this load type to keep data in separate reporting and analytics systems up to date so that you can make informed decisions for your business or organization based on the latest data. You can also use this load type to feed the latest changes to data warehouses and cloud data lakes for big data processing.
Initial and incremental load
. Performs an initial load of point-in-time data to the target and then automatically switches to propagating incremental data changes made to the same source tables on a continuous basis.
For more information about the sources and targets supported for each load type, see "Mass Ingestion Databases source and target types."
A
database ingestion
task automatically maps source tables and fields to target tables and fields based on name matching. You can define rules to customize the target table names.
ASK INFAPreview
