Informatica IDMC CDI ( Cloud Data Integration) - IICS ETL Live Training

Course Description

Demo Video:

Demo session - Informatica IDMC CDI Live training

Course Content:

Module 1: Informatica Cloud Overview

1. What’s Is ETL/Concepts Informatica Basics

2. Informatica Intelligent Cloud Services (IICS) as an iPaaS solution

3. Informatica Cloud Terminologies

4. Informatica Cloud Architecture

5. CDI Assets

6. CDI Components

7. Lab: Navigating the IICS interface 

Module 2: Runtime Environments and Connections

1. Runtime Environments

2. Secure Agent Architecture

3. IICS Log Files

4. Connections

5. Connection Types

6. Creating Connections

7. Lab: Installing Secure Agent

8. Lab: Creating a Salesforce connection -- Basic

9. Lab: Creating a Flat File connection

10. Lab: Creating a AWS Redshift/S3 connection/Athena

11. Lab: Creating an Oracle connection

Module 3: Synchronization Task

1. Synchronization Task Overview

2. Synchronization Task – Definition Step

3. Synchronization Task – Source Step

4. Synchronization Task – Target Step

5. Synchronization Task – Data Filters Step

6. Synchronization Task – Field Mapping Step

7. Synchronization Task – Schedule Step

8. Activity Monitor

9. Lab: Creating a Synchronization Task

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

Module 4: Cloud Mapping Designer

1. Cloud Mapping Designer Overview

2. Mapping Designer Terminologies

3. CLAIRE Transformation Recommendations

4. Mapping Data Preview

5. Field Rules

6. Best Practices for Creating Mappings

7. Data flow run order

8. Mapping Task

9. Deploy mapping updates

10. Note: Components / Mapplets and taskflow

Module 5: Cloud Mapping Designer - Transformations

1. Source Transformation

2. Target Transformation

3. Filter Transformation

4. Joiner Transformation

5. Expression Transformation

6. Lookup Transformation

7. Union Transformation

8. Mapplets

9. SQL Transformation

10. Aggregator Transformation

11. Normalizer Transformation

12. Rank Transformation

13. Sequence Generator Transformation

14. Java Transformation

15. Lab: Using Query in a Mapping

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

17. Lab: Using Unconnected Lookup transformation in a mapping

18. Lab: Using Mapplet transformation in a mapping

Module 6: Mapping Parameters

1. Note : All Param files on S3 and use it.

2. Parameterization use cases

3. Adding Parameters to a Mapping

4. Creating parameters

5. Parameter Types

6. Using parameter files

7. Parameter Best Practices

8. Lab: Performing Complete Parameterization

9. Lab: Using Parameter File in a Mapping task

10. Lab: Using In-Out parameters for incremental data loading 

Module 7: Expression Macro and Dynamic Linking

1. Expression Macro

2. Dynamic Linking

3. Lab: Using Expression Macro in a mapping

4. Lab: Using Dynamic Linking in a mapping 

Module 8: Replication Task

1. Replication Task Overview

2. Replication Task Features

3. Replication Task: Source and Target Options

4. Other Replication Task Options

5. Resetting the Target Table

6. Generating Non-Unique Index

7. Lab: Create a Replication Task  

Module9: Masking Task

1. Masking Task Overview

2. Masking Task: Source and Target Options

3. Data Subset: Row Limits and Data Filters

4. Field Masking Rules

5. Masking Rule Types

6. Refresh Masking Task metadata

7. Reset a Masking Task

8. Masking Best Practices

9. Lab: Create Masking task

Module 10: Mass Ingestion Task

1. Mass Ingestion Task Overview

2. Functionalities

3. Configuring a Mass Ingestion Task

4. Creating a Mass Ingestion Task

Module 11: Taskflows

1. Task flow overview

2. Linear Taskflows

3. File Listener Enhancements

4. Taskflow Steps

5. Taskflow Templates

6. Using REST APIs

7. Invoke a Taskflow through a File Listener

8. Lab: Passing in-out parameters in a Taskflow

9. Lab: Invoking a Taskflow through a File Listener 

Module 12: Hierarchical Connectivity

1. Web Service transformation

2. REST V2 Connector

3. Hierarchical Schemas

4. Hierarchy Parser Transformation

5. Hierarchy Builder Transformation

6. Lab: Creating a mapping using a REST V2 connector

7. Lab: Using Web Services transformation in a mapping

8. Lab: Using Hierarchy Parser and Hierarchy Builder Transformation

Module 13: Intelligent Structure Model

1. Intelligent Structure Model

2. Intelligent Structure Discovery Process

3. Intelligent Structure Example

4. Refining a Discovered Structure

5. Editing an Intelligent Structure Model

6. Using intelligent structure models in Structure Parser transformation

7. Lab: Creating an Intelligent Structure Model

8. Lab: Using Structure Parser transformation in a mapping 

Module 14: Advanced Task Settings and Performance Tuning

1. Primary Key Chunking

2. Lookup SQL Override

3. Partitions Overview

4. Types of Partitions

5. Partitioning Rules and Guidelines

6. Pushdown optimization overview

7. Types of pushdown optimization

8. Cross-schema pushdown optimization

9. Pushdown optimization user-defined parameters

10. Pushdown compatible connections

11. Secure agent groups

12. Secure agent groups with multiple agents

13. Shared secure agent groups

14. DTM performance properties

Module 15: Exception Handling

1. Types of exceptions

2. User-defined exceptions

3. Non-fatal exceptions

4. Default Field Value Setting

5. Row Error Logging

6. Error handling settings

7. Fatal exceptions

8. Bad files or Reject files

9. Lab: Creating a mapping to handle non-fatal errors 

Module 16: Administration

1. Licenses

2. Administrator Service

3. User Roles (System-defined Roles and Custom Roles)

4. Creating a User

5. User Groups

6. Permissions

7. Object-Level Permissions

8. Organization Hierarchy

9. Sub-Organization

10. Importing and Exporting Assets

11. Asset Dependency

12. Add-on Bundles

13. Lab: Configure Administrative settings for your Informatica Cloud org 

Module 17: Automating and Monitoring Tasks

1. Schedules

2. Schedule Repeat Frequency

3. Schedule Blackout Period

4. Schedule Export

5. Monitoring tasks

6. Email Notifications

7. Event Monitoring

8. Lab: Creating a schedule

9. Module 20: Operation Insight

10. Discuss Informatica Discovery IQ

11. List the features of Discovery IQ

12. Exploring Discovery IQ features

Module 18: External Tool & Practical (Scenario Based )

1. Trial Account : Snowflake , Saleforce ,Oracle,IICS,Postman

2. Scenario Based Practical’s

3. CDC

4. SCD1/SCD2/SCD3 

Module 19 : Additional

1. PC to IICS Migration

2. Certifications Questions/Dumps

3. Sample Project explanation on IICS

4. Sample Resume/Points on IICS

Practice Handbook for Scenario