Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Ingesting Db2 for i Change Data into Snowflake with Cloud Mass Ingestion Databases

Ingesting Db2 for i Change Data into Snowflake with Cloud Mass Ingestion Databases

Overview

Overview

This article describes how to implement a database ingestion incremental load task that replicates change data from a Db2 for i source to a Snowflake Data Cloud target. It covers initial setup tasks for the Mass Ingestion environment and how to configure, deploy, run, and monitor a database ingestion task.
The use cases for replicating real-time change data from a mission-critical Db2 for i production system to a Snowflake data warehouse include:
  • Minimizing intrusive, non-critical work, such as offline reporting or analytical operations on the Db2 for i source database system.
  • Reducing costly CPU usage, disk space, and CDC processing time on the Db2 for i source database system.
  • Getting the latest database changes to your data warehouse in real time for downstream processing.
  • Migrating to a subscription-based Cloud environment.
For more information, see the Cloud Mass Ingestion documentation on the Doc Portal at https://docs.informatica.com/integration-cloud/cloud-mass-ingestion/current-version.html.

0 COMMENTS

We’d like to hear from you!