Informatica Data Integration , Intelligent Cloud Services

Practices Tests Certification Informatica R34,IICS,Cloud 101,Cloud 201

Informatica Data Integration , Intelligent Cloud Services
Informatica Data Integration , Intelligent Cloud Services

Informatica Data Integration , Intelligent Cloud Services udemy course

Practices Tests Certification Informatica R34,IICS,Cloud 101,Cloud 201


This test measures your knowledge of Informatica Cloud Services Data and Application Integration. Measured areas include Informatica Cloud architecture, data integration features, data synchronization, cloud mapping designer, data masking, and data replication. It will test your knowledge of integrating applications and systems, the implementation of business processes, using the process designer, and exposing composite APIs.

You may select from one or more response offerings to answer a question. The test will contain 135 questions comprised of topics that span across the sections  below.

Module 1: Informatica Cloud Overview

  • Informatica Intelligent Cloud Services (IICS) as an iPaaS solution

  • Informatica Cloud Terminologies

  • Informatica Cloud Architecture

  • CDI Assets

  • CDI Components

  • Lab: Navigating the IICS interface

Module 2: Runtime Environments and Connections

  • Runtime Environments

  • Secure Agent Architecture

  • IICS Log Files

  • Connections

  • Connection Types

  • Creating Connections

  • Lab: Installing IICS Secure Agent

  • Lab: Creating a Salesforce connection

  • Lab: Creating a Flat File connection

  • Lab: Creating an Oracle connection

Module 3: Synchronization Task

  • Synchronization Task Overview

  • Synchronization Task – Definition Step

  • Synchronization Task – Source Step

  • Synchronization Task – Target Step

  • Synchronization Task – Data Filters Step

  • Synchronization Task – Field Mapping Step

  • Synchronization Task – Schedule Step

  • Activity Monitor

  • Lab: Creating a Synchronization Task

  • Lab: Using Filter, Expression and Lookup in a Synchronization Task

Module 4: Cloud Mapping Designer

  • Cloud Mapping Designer Overview

  • Mapping Designer Terminologies

  • CLAIRE Transformation Recommendations

  • Mapping Data Preview

  • Customizing Mapping Preview

  • Field Rules

  • Best Practices for Creating Mappings

  • Data flow run order

  • Mapping Task

  • Deploy mapping updates

Module 5: Cloud Mapping Designer - Transformations

  • Source Transformation

  • Target Transformation

  • Filter Transformation

  • Joiner Transformation

  • Expression Transformation

  • Lookup Transformation

  • Union Transformation

  • Mapplets

  • SQL Transformation

  • Aggregator Transformation

  • Normalizer Transformation

  • Rank Transformation

  • Data Masking Transformation

  • Java Transformation

  • Lab: Using Query in a Mapping

  • Lab: Using Normalizer, Aggregator, and Rank transformations in a mapping

  • Lab: Using Unconnected Lookup transformation in a mapping

  • Lab: Using Mapplet transformation in a mapping

Module 6: Mapping Parameters

  • Parameterization use cases

  • Adding Parameters to a Mapping

  • Creating parameters

  • Parameter Types

  • Using parameter files

  • Parameter Best Practices

  • Lab: Performing Complete Parameterization

  • Lab: Using Parameter File in a Mapping task

  • Lab: Using In-Out parameters for incremental data loading

Module 7: Expression Macro and Dynamic Linking

  • Expression Macro

  • Dynamic Linking

  • Lab: Using Expression Macro in a mapping

  • Lab: Using Dynamic Linking in a mapping

Module 8: Replication Task

  • Replication Task Overview

  • Replication Task Features

  • Replication Task: Source and Target Options

  • Other Replication Task Options

  • Resetting the Target Table

  • Generating Non-Unique Index

  • Appendix: Replicating Data to a Flat file

Module 9: Masking Task

  • Masking Task Overview

  • Masking Task: Source and Target Options

  • Data Subset: Row Limits and Data Filters

  • Field Masking Rules

  • Masking Rule Types

  • Refresh Masking Task metadata

  • Reset a Masking Task

  • Masking Best Practices

  • Appendix: Creating a Masking Task

Module 10: Mass Ingestion Task

  • Mass Ingestion Task Overview

  • Functionalities

  • Configuring a Mass Ingestion Task

  • File Ingestion Task

  • Database Ingestion Task

  • Streaming Ingestion Task

  • Lab: Creating a Streaming Ingestion Task

Module 11: Taskflows

  • Taskflow overview

  • Linear Taskflows

  • File Listener Enhancements

  • Taskflow Steps

  • Taskflow Templates

  • Parameters in Taskflow

  • Using REST APIs

  • Invoke a Taskflow through a File Listener

  • Lab: Passing in-out parameters in a Taskflow

  • Lab: Invoking a Taskflow through a File Listener

Module 12: Hierarchical Connectivity

  • Web Service transformation

  • REST V2 Connector

  • Hierarchical Schemas

  • Hierarchy Parser Transformation

  • Hierarchy Builder Transformation

  • Lab: Creating a mapping using a REST V2 connector

  • Lab: Using Web Services transformation in a mapping

  • Lab: Using Hierarchy Parser and Hierarchy Builder Transformation

Module 13: Intelligent Structure Model

  • Intelligent Structure Model

  • Intelligent Structure Discovery Process

  • Intelligent Structure Example

  • Refining a Discovered Structure

  • Editing an Intelligent Structure Model

  • Intelligent structure models based on an XSD file

  • Using intelligent structure models in Structure Parser transformation

  • Lab: Creating an Intelligent Structure Model

  • Lab: Using Structure Parser transformation in a mapping

Module 14: Advanced Task Settings and Performance Tuning

  • Primary Key Chunking

  • Lookup SQL Override

  • Partitions Overview

  • Types of Partitions

  • Partitioning Rules and Guidelines

  • Pushdown optimization overview

  • Types of pushdown optimization

  • Pushdown optimization user-defined parameters

  • Secure agent groups

  • Shared secure agent groups

  • DTM performance properties

Module 15: Exception Handling

  • Types of exceptions

  • User-defined exceptions

  • Non-fatal exceptions

  • Default Field Value Setting

  • Row Error Logging

  • Error handling settings

  • Fatal exceptions

  • Bad files or Reject files

  • Lab: Creating a mapping to handle non-fatal errors

Module 16: Administration

  • Licenses

  • Administrator Service

  • User Roles (System-defined Roles and Custom Roles)

  • Creating a User

  • User Groups

  • Permissions

  • Object-Level Permissions

  • Organization Hierarchy

  • Sub-Organization

  • Importing and Exporting Assets

  • Asset Dependency

  • Add-on Bundles

  • Lab: Configure Administrative settings for your Informatica Cloud org

  • Lab: Creating a sub-organization and importing/exporting assets

Module 17: Automating and Monitoring Tasks

  • Schedules

  • Schedule Repeat Frequency

  • Schedule Blackout Period

  • Schedule Export

  • Monitoring tasks

  • Email Notifications

  • Event Monitoring

  • Lab: Creating a schedule

Module 18: IICS APIs

  • REST API overview

  • Informatica Cloud REST API

  • REST API Versions

  • Request Header and Request Body configuration

  • Return Lists

  • Demo: RunAJob Utility

  • Lab: Running a Mapping task using REST API