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

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.

Click here to view the Data Integration NetSuite Connector Guide, which contains information about how to set up and use NetSuite Connector. The guide explains how organization administrators and business users can use NetSuite connections to securely read data from or write data to NetSuite.

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. 

This webinar is intended for IICS customers who are using Cloud Data Quality or want to know more about the same.

At the end of this session, customers will be able to get insights about the dimensions of Data Quality, how to create and manage rule specifications and dictionaries in IICS, and how to use Data Profiling to create and run data profiling tasks.

This session is intended for IICS customers who want to optimize performance of tasks using Partitions and Pushdown optimization.

After this session, customers would be able to create partitions, utilize Pushdown optimization to improve performance of their tasks.