top of page

Informatica Power Center Cloud

Roman Echeverria
Jul 6, 2021
2 min read

Updated: Jul 8, 2021

Start Date: 4/Oct/2021

Seats: 20

Language: Spanish

Location: Remote (Zoom)

Duration: 11 hours


Description:


In this course you will learn all the basics from informatica Power Center, by the end of the course you will be able to develop real business ETL jobs and you will be able to understand many complex transformations and functionality


provided by the tool.


Some of the concepts you will learn are: Expression transformation, Filter transformation

,Router transformation, Lookup transformation, Union transformation, Sorter transformation, Aggregator transformation, Rank transformation, Sequence generator transformation, Stored procedure transformation& many more...










Course content:


1-Starting with IPC Cloud


Cloud Computing

What are the different types of Cloud Computing?

Infrastructure as a Service - IaaS

Platform as a Service - PaaS

Software as a Service - SaaS


2-IICS - Informatica Intelligent Cloud Services


What is IPaas?

Power Center On premise Vs Informatica Cloud

Power Center On Cloud Vs Informatica Cloud

Different Components of Informatica Cloud

Informatica Cloud Architecture

Informatica Cloud Connectivity and Secure Agent

Commonly used terms


3-Getting Started with IICS


How to create a Informatica Cloud account?

What are the different Services available in Informatica Cloud?

Data Integration Service - Page Layout

Administration Service - Page Layout

Monitor Service - Page Layout

Steps to download and install secure agent


4-Data Integration Service


Folder Creation under Explore Option

Mapping Designer - Layout

How to configure a reusable Flat File connection?

How to configure a reusable Relational connection for an on-premise database?

Steps to create the mapping and execute it.

Secure Agent Setup and Re-usable Connection creation

Copy to and Move to options

How are the environments setup work in the cloud?

What are Sub Organizations and how to link Sub Organizations?

Mapping creation without any linking of ports


5-Transformations in Informatica Cloud


Introduction to Transformations in Informatica Cloud

Aggregator Transformation - Properties and Example

Sorter Transformation - Properties, Example --> Part 1

Sorter Transformation - Properties, Example --> Part 2

Filter Transformation - Properties, Example

Router Transformation - Properties, Example

Sequence Generator Transformation - Properties, Example

Union Transformation - Properties, Example

Source Type - File List

Lookup Transformation - Properties, Example

Unconnected Lookup Transformation - Properties, Example

Normalizer Transformation


6-Business Use Case


Business Use Case Introduction

Sources and Targets used for the Use Case


7-Tasks


Introduction to Tasks

Mapping Task - Creation and Example

Synchronization Task

Database to Database Replication Example

Database to File Replication Example

PowerCenter Task - Import of Workflow XML and Example


8-Scheduling in Informatica Cloud

Reusable and non-reusable schedules in Informatica Cloud

 
 
 

Comments


Commenting on this post isn't available anymore. Contact the site owner for more info.
Data Creed - Black Background.png

©2027 Data Creed

bottom of page