Cloud Data Warehouse Journey

Watch this video to learn about the features and benefits of pushdown optimization in Informatica Cloud Data Integration.

Watch this video to learn how to optimize mapping performance when you load data to a cloud data warehouse in Informatica Cloud Data Integration.

Watch this video to learn how to optimize ecosystem mapping performance in Informatica Cloud Data Integration using pushdown optimization.

Because your data source and target are in the same datastore, moving data out of the cloud data warehouse (CDW) for processing and bringing it to post-processing is inefficient and costly. Learn how to use APDO to process data directly in your CDW with this video. 

Here's a blog that will help you understand how Advanced pushdown optimization (APDO) eliminates the time-consuming tasks of pulling the transformation logic out of the cloud infrastructure, transforming it, and then moving it back into the cloud again. And the reduced overall processing time drops the data egress cost, resulting in a significant cost-benefit for the customer.

Read this blog to understand how Informatica’s advanced pushdown optimization capabilities are suited to any organization that wants to bring scalable, cost-efficient, and highly productive ELT integration to its data architecture. The bottom line is that you need ELT, but you also need the option not to use it.

If you have been using a data warehouse in your organization or are planning to build one, chances are you have already heard about ETL and ELT. Here's a blog that discusses the differences between ETL and ELT, the benefits of ELT in the cloud, and more. 

Read this blog to clarify the difference between APDO- and ODBC-based pushdown. It will also provide guidelines on what is best for your ELT process.

Informatica and Snowflake enable you to integrate, synchronize, replicate, and combine data from a broad range of data sources while ensuring quality and consistency. Check out this blog to learn more. 

SCD2 Mapping

Watch this video to learn how to optimize mapping performance when you load data from Type 2 Slowly Changing Dimension tables to Snowflake in Informatica Cloud Data Integration.

Creating a Snowflake Connection

This video shows how to configure the Snowflake Cloud Data Warehouse V2 connection using the Standard, KeyPair, and Authorization Code authentication methods from Informatica Cloud Data Integration.