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 the Informatica cloud architecture and ICS repository, including metadata, encrypted connections, scheduling, monitoring, wizards, and the secure agent, with no company data stored in the cloud.

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.

Learn how Informatica Cloud Secure Agent generates and uses log files for debugging and task tracking, including session logs, error logs, Salesforce target logs, and Tomcat and info agent logs.

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.

Discover how Informatica Cloud connections link cloud and on-premises data, using native and add-on connectors to create reusable connections and configure sources like Salesforce and OData.

Create a Salesforce developer account by signing up for the Salesforce developer edition, verifying your email, and setting a password to log in.

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.

Navigate the data integration interface and cloud mapping designer to create, move, rename, and copy mappings. Manage folders like the default and Salesforce project, and explore mapping options.

Update Salesforce accounts by adjusting formatting, previewing data with correct delimiters, removing unnecessary columns, and mapping IDs to perform an update in Informatica Cloud (IICS).

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.

Prevent invalid record id errors by filtering null ids from the lookup and deleting only Salesforce accounts that exist, using isnull and if functions and the assertion log as guidance.

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 how the monitor service displays all job logs across the organization, including running and completed tasks, import/export logs, session logs, and tracing levels for debugging with performance trade-offs.

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.

Replace the csv source with a fixed-width file using expression transformation to trim spaces and rename fields, then map product id, category, and order id to the fixed-width target.

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.

Explore using the sorter transformation to sort data after a join, manage ascending and descending order, and leverage options like case sensitivity, distinct, and null handling.

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.

Use a union transformation to merge orders data from two Oracle tables, apply a sequence transformation to generate a field starting at 100 for each row.

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 how the synchronization task fits within the data integration service, offering a beginner-friendly, standardized flow to synchronize data between Salesforce and a flat file.

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.

Run PowerCenter workflows in the data integration service by uploading XML files from PowerCenter or Informatica Marketplace, and decide whether to use PowerCenter task for on-premise flows that won’t change.

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.

Explore incremental data loading in Informatica Cloud using in-out parameters and expression transformations to track the max employee ID, update the in-out parameter, and verify with a second target.

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.