Informatica Power Center Cloud
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