Informatica Powercenter Development Training

Table of Content

Data Warehousing
• What Is Data Warehouse?
• Explain OLTP, OLAP
• Explain Schemas
• Sql basics and analytical functions

Installation
• Pre-build VMware setup
• Informatica Client-Server setup guide on personal system

First Steps
• What Is Etl?
• What Is Informatica?
• Informatica Architecture Overview
• Explain Informatica PowerCenter Components
• Designer
• Repository Manager
• Workflow Manager
• Workflow Monitor
• PowerCenter Admin Console

Sources
• Relational Sources(Data Bases)
• Files Sources(Flat File, Xml, Cobol)

Targets
• Relational Targets(Data Bases)
• Files Targets

Transformations
• What Is Transformation
• Type Of Transformation
o Active Transformations
o Passive Transformations
• Expression Transformation
• Filter Transformation
• Router Transformation
• Sorter Transformation
• Rank Transformation
• Source Qualifier Transformation
• Aggregator Transformation
• Joiner Transformation
• Sequence Generator Transformation
• SQL Transformation
• Stored Procedure Transformation
• Lookup(Different Type Of Lookup) Transformation
• Union Transformation
• Normalizer Transformation
• Update Strategy Transformation
• Slowly Changing Dimension
• SCD Type-1
• SCD Type-2(Date, Flag And Version)
• SCD Type-3

Workflow Manager
• Create Reusable Tasks
• Workflows, Sessions And Worklets
• Task
• Session
• Decision Task
• Control Task
• Event Wait Task
• Timer Task
• Monitoring Workflows And Debugging Errors

• Indirect Loading
• Constraint Based Load Ordering
• Target Load Plan
• Worklet, Mapplet
• Reusable Transformation
• Migration
• Xml Migration & Folder Copy
• Scheduling Workflow
• Parameter and Variables
• Performance Tuning
• Partition

• Informatica Intelligent cloud services – Introduction and roadmap
• Informatica Cloud Overview
• Informatica Cloud Secure Agent and Architecture
• Creating Connections
• Data Synchronization Application
• Data Replication Application
• Cloud Mapping Designer
• Task flows
• Performance and Scalability

• Additional topics
• SQL beginner course
• Unix basis commands
• Real time scenarios

Contact Us

We are always here to guide you...

Quick Enquiry

Please enter name.
Please enter name.
Please enter valid email adress.
Please enter Course name.
Please enter your comment.

sitcomputerairoli@gmail.com

+91 9619 3417 13

+91 7506 4114 34

Website : www.sitcomputer.in

We Are Social