Informatica Cloud (IICS) - The Complete Guide 2025 Edition

Explore core terminology such as source, destination, target, and task types like mapping, synchronization, replication, and masking in Informatica Cloud, and learn how connections, authentication, and organization enable data movement.

Learn Informatica Cloud as an iPaaS for connecting data across cloud and on-premises, using connectors, mappings, and transformations to build integrations like loading CSV data into Salesforce.

Learn how to create a simple Informatica Cloud trial account, access cloud data integration services without installation, and compare university vs cloud trial options for training.

Install the secure agent to access local resources behind the firewall. Explore Informatica Cloud's data integration, application integration, and data ingestion services.

Explore Informatica Cloud runtime environments: cloud hosted agent, serverless runtime environment, and secure agent. Learn when to use each, licensing, limitations, and how data stays behind the firewall.

Explore the secure agent architecture and its role in Informatica Cloud connectivity, including runtime environments, pluggable microservices, and how it accesses local resources behind the firewall to connect with Salesforce.

Explore the course structure and teaching approach for each IICS lesson, featuring a brief upfront slideshow that outlines key topics, promotes clarity, and allows review after class to reinforce learning.

Explore Informatica University and IICS documentation to access curriculums, cloud data integration resources, and practical labs. Discover trial accounts, the masking task, and certification paths to validate your expertise.

Explore Informatica Cloud’s data integration service interface and assets. Learn about mappings and task flows, create connections, and use a file listener.

Create a Salesforce connection in Informatica Cloud by adding the Salesforce connector, configuring a local secure agent, entering username, password, and security token, then test and save.

Configure the Informatica Cloud Secure Agent to run under an admin user when multiple users exist, by updating the Windows service logon and restarting the agent to access local resources.

Create and run a mapping in Informatica Cloud to load data from a local flat file into Salesforce, using a filter to insert accounts with more than ten employees.

Automate updating Salesforce accounts by using a lookup transformation that matches the company name to fetch the account id and update records, eliminating manual file modifications.

Learn to upsert Salesforce accounts from a flat file using a lookup-based mapping, updating or creating records with employees greater than ten, and schedule mapping to run every 24 hours.

Delete Salesforce accounts with ten or fewer employees using a mapping from Excurse flat files and an employees filter. Orchestrate daily with upsert, wait 30 seconds, then delete.

Explore the software life cycle with development, testing, and production environments, and learn how to export mappings with dependencies and migrate them in Informatica Cloud.

Learn to join data from Oracle and flat-file sources using the joiner transformation in a mapping, selecting specific fields via a query and setting a product ID join condition.

Learn to install and configure Oracle database and SQL Developer, download 19c/21c, create admin Windows user, set Oracle Home, create CDI user, and verify connections.

Create the Oracle table orders from the Informatica University file, run the script, verify creation, then build an Oracle database connection in the Informatica Administrator service using a Secure Agent.

Compute total order value with an expression transformation by converting unit price and quantity to integers, then route results to two csv files using filters based on total value.

Use the aggregator transformation to group by employee ID and sum quarterly earnings in Informatica Cloud, configuring mapping and an expression transformation for integer conversion.

Learn how to split a single mapping into multiple flows using a router transformation to generate separate employee reports with dynamic file naming and runtime file creation.

Combine two employee profit files with a file list source, normalize quarterly data into rows using a normalizer, and identify top five employees of the last quarter with rank transformation.

Compare union and joiner transformations: union merges multiple sources vertically without a join condition; joiner requires a join condition and supports normal, left, right, and full outer joins.

Join multiple flat files with the command source type in Informatica Cloud, using a shell script and secure agent, then apply data masking and data quality assets.

Learn to replicate Oracle tables to flat files using a replication task, configure the target and load types (full, incremental with upsert or time-based partial), and manage deletes.

Mask sensitive fields in Salesforce contact data with a masking task that uses realistic test data, preserves phone, email, and birth date formats, and supports repeatable outputs with seed values.

Transfer data from Salesforce to a local CSV using a data transfer task, applying a finance department filter and a lookup to flag loyal customer cards in the flat file.

Learn to build a completely parameterized Informatica Cloud mapping using input and in-out parameters, enabling runtime overrides, flexible source and target connections, and parameterized filters and mappings.

Learn to use a parameter file in a mapping task to update filters without editing the task, including global and task-specific sections and cloud or local file locations.

Implement incremental data loading in IICS using system variables to filter by modified date, loading only updated Oracle records to the target and adjusting time zones.

Apply vertical macros in the IICS expression transformation to cleanse all fields: trim spaces, capitalize first letters, and replace empties with Unknown, using input and output macro fields.

Create a mapping with a horizontal macro to filter null values from a flat file. Use an expression across all fields to sum null checks and filter out incomplete rows.

Combine vertical and horizontal macros into a hybrid macro to format flat file data, replacing entire rows with null when any field is empty, using input macro field and output macro field.

Convert hierarchical input from XML or JSON into relational output using the hierarchy parser transformation, guided by schema setup and input format options for file or buffer.

Convert relational input into hierarchical output using the hierarchy builder and a hierarchical json schema, mapping fields to a single root array for json or xml output.