Learn how to optimize mapping performance when you load data from Type 2 Slowly Changing Dimension tables to Snowflake in Informatica Cloud Data Integration.
Watch this video to learn how to create a Snowflake V2 connection in IICS Administrator: https://youtu.be/8euZ8GP7sDc
Timestamps:
00:00 Introduction
00:49 Create a Snowflake V2 mapping
06:52 Create a Snowflake V2 mapping task
07:40 Verify the mapping behavior
For more information, see the Pushdown Optimization chapter in the Snowflake Cloud Data Warehouse V2 Connector Guide on the Informatica documentation portal: https://docs.informatica.com/integration-cloud/cloud-data-integration-connectors/current-version/snowflake-cloud-data-warehouse-v2-connector/snowflake-pushdown-optimization.html
Try Cloud Data Integration free for 30 days! Click for details: https://www.informatica.com/trials/cloud-data-integration.html
Learn more about Cloud Data Integration here:
https://www.informatica.com/products/cloud-integration/cloud-data-integration.html