Click here to know how to do full pushdown optimization with Azure DataWarehouseV2 ODBC connector in CDI.

You can use pushdown optimization to push transformation logic to source databases or target databases for execution. Use pushdown optimization when using database resources can improve task performance. 

Learn More

This video explains parameterization and its uses with the help of an example, advanced parameterization, Rest utilization and Rest Tools and discussing advantages of Rest API and parameterization.

Click here to understand more about parameters and their types that include Input parameters, In-Out parameters and parameter files. 

Click here to understand more about In-Out parameters, which are a placeholder for a value that stores a counter or task stage. Data Integration evaluates the parameter at run time based on your configuration. 

Click here to know how to use In-out parameters in the Cloud Mapping Designer.

Click here to know how to use In-Out parameters in Informatica Cloud.

Watch this video that gives an overview of Dynamic Linking. It also discusses how to use the Create a New Runtime option.

An Expression Macro is a macro that you can use to create repetitive or complex expressions in mappings.

Watch this video that will take you through the different types of Expression Macro. 

This video will help you understand what an Aggregator Transformation is and how it is created. It will also help you know how it is applied to aggregate functions such as sum, and average on groups of data,. This video also discusses Normalizer transformations and how to create a mapping using Normalizer transformation.

Click here to understand more about Java transformation and extend Data Integration functionality with the Java transformation.

Click here to understand more about Union transformation, which is an active transformation that you use to merge data from two pipelines into a single pipeline.

How to Read Log Files for Cache Information for Disk Space Requirement

Click here to know how to change the cache directory for IICS Data Integration cache files (for joiner, sorter, aggregator, and lookup transformations.

Here are few useful resources:

Learn More about SAML SSO in IICS

Learn More about SAML SSO using OKTA in IICS

How to export and import assets in IICS using REST API's

This video gives you an overview of the new Informatica Processing Unit (IPU) Metering and Dashboard in IICS. It also covers examples of the IPU calculation and demo of the IPU metering dashboard. 

SAP Connection

Click here to view the Data Integration SAP Connector Guide, which contains information on how to set up and use SAP Connector. The guide also explains how organization administrators and business users can use the SAP Connector to read from and write data to SAP.

Workday V2 Connector Guide

Click here to go through the Data Integration Workday Connector Guide, which contains information on how to set up and use Workday Connector. The guide explains how organization administrators and business users can use Workday Connector to perform operations in multiple Workday modules.

Netsuite

Click here to know how to increase the performance of the Netsuite V1 connector tasks by increasing the concurrent threads in IICS.

Rest V2 connector and Swagger

The Data Integration REST V2 Connector Guide contains information on how to set up and use REST V2 Connector. The guide also explains how organization administrators and business users can use REST V2 Connector to read data from and write data to a web service that supports REST API.

Data Integration REST V2 Connector Guide

HOW TO: Generate Swagger file in IICS

HOW TO: Create Swagger file for Login API resource in IICS CDI

Hadoop Connection

Click here to view the Data Integration Hadoop Files V2 Connector Guide, which contains information on how to set up and use Hadoop Files V2 Connector. This guide also explains how organization administrators and business users can use Hadoop Files V2 Connector to securely read data from or write data to complex files on the local system or in HDFS.

Learn how to track and monitor the status of all ETL tasks and secure agents in the environment in IICS.

Watch the video to learn how to:

• Monitor user login activity, projects, and folders updates
  
  
• Monitor bundle usage in the organization

This video discusses how to create and publish a bundle in Marketplace.

Learn how to copy a pre-existing bundle to development projects or folders to improve productivity and quality of data integration projects.

Learn how to create and run a mass ingestion task to transfer high volume data to the target system.

Learn how to use Mapping Designer to configure source to target mappings, add expression transformations, and sort transformations for cleansing.