Sharpen your data warehousing skills by mastering the techniques of Informatica PowerCenter
What you'll learn
Get familiar with the admin console
Add transformations using input and output ports
Work with the repository manager screen
Classify active, passive, connected, and unconnected transformations
Work on parameter files and gain an insight to the scheduling workflow
Find out how to debug and identify issues in mappings
Configure the internal scheduler and file lists
Get equipped to handle different types of partitions
Requirements
Basic understanding of ETL and PowerCenter is needed
Description
Informatica is a leader in the ETL market and provides lot of job opportunities in the industry. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse. The main components of Informatica PowerCenter are its client tools, server, repository server and repository. The PowerCenter server and repository server make up the ETL layer, which completes the ETL processing. If you're interested to work with various transformations and implement different types of SCDs in PowerCenter 9 to create reusable transformations and mapplets, then go for this Learning Path.
Packt's Video Learning Paths are a series of individual video products put together in a logical and stepwise manner such that each video builds on the skills learned in the video before it.
The highlights of this Learning Path are
Learn to use the designer screen
Use advanced transformations such as Rank and Joiner to classify active, passive, connected, and unconnected transformations
Implement SCD1, SCD2, and SCD3 mappings
This Learning Path will kick-start with taking you through downloading Informatica Power Center and extracting it. It will help you to gain a deeper insight at various aspects of the Informatica administrator console, such as domains, node, repository and integration service. You will then learn to import and create a source and target, and move on to creating mappings and using transformations ports. Next, the course will walk you through the Workflow Manager Screen and skill you to set up a path and connection. You will also learn how to work with the repository manager screen and thus, make the optimum use of Informatica Power Center!
Further, you will learn how to use transformations such as aggregator and filter, after which you will move onto more advanced transformations such as Joiner, Union, and Rank. You will also learn to debug a mapping, which will help you identify any issues in mappings. You'll be introduced to the advanced aspects of the Designer and Workflow Manager screens. Finally, you'll find out how to create reusable transformations and mapplets. Then, we move on to working with the target load plan and you'll learn to compare objects.
By the end of this Learning Path, you will be able to work with various transformations and implement different types of SCDs to master the advanced aspects of the Informatica client to create reusable transformations and mapplets.
Meet Your Experts
We have combined the best works of the following esteemed author to ensure that your learning journey is smooth
Rahul Malewar has been working on various Data Warehousing tools for 10 years, mostly on Informatica Power Center. He has worked on various versions of Informatica Power Center starting at version 8.1 up to the latest version 9.x and Informatica Cloud. He has worked for various MNCs in India such as UST Global, Cognizant Technologies, and Principal Financial services in Pune. He has worked on the implementation of some Data Warehouses involving Informatica for fortune 500 MNCs such as Wellpoint and Principal. He has experience of working on multiple real-time projects in MNCs. He has run his own training center named Learn Well Technocraft since 2010, which provides training on more than 25 Data Warehousing technologies via classroom, corporate, and online. He has also written a blog on data warehousing concepts. As of today, he has provided training to more than 1200 candidates ranging from freshers to 20-year experienced professionals. He is also a Director of a software firm named Gut Lernen Technocraft Pvt. Ltd., where they work on data warehousing and mobile-related projects. He provides free assistance on Informatica installation related and other technical issues.
Overview
Section 1: Getting Started with Informatica
Lecture 1 The Course Overview
Lecture 2 Downloading the Tool
Lecture 3 Extracting the Tool from Its .zip File
Lecture 4 Installing the Server
Lecture 5 Installing the Client
Lecture 6 Configuring Domain and Node
Lecture 7 Configuring Repository and Integration Service
Lecture 8 Configuring Users and Granting Permissions
Lecture 9 Configuring the Repository Manager
Lecture 10 Using the Designer Client Interface
Lecture 11 Working with Sources as Files and Databases
Lecture 12 Working with Targets as Files and Databases
Lecture 13 Creating a New Mapping
Lecture 14 Adding Transformation Using Input and Output Ports
Lecture 15 Using the Workflow Manager Interface
Lecture 16 Using the Workflow Manager
Lecture 17 Setting the Source And Target Paths
Lecture 18 Executing the Workflow
Lecture 19 The Workflow Monitor
Lecture 20 The Workflow Log, Session Log, And Run Properties
Lecture 21 Copy-Paste and Drag-Drop Features
Lecture 22 The Export-Import Feature
Section 2: Implementing Informatica PowerCenter 9
Lecture 23 The Course Overview
Lecture 24 The Expression Transformation
Lecture 25 The Aggregator Transformation
Lecture 26 The Sorter Transformation
Lecture 27 The Filter Transformation
Lecture 28 The Router Transformation
Lecture 29 The Rank Transformation
Lecture 30 The Joiner Transformation
Lecture 31 The Union Transformation
Lecture 32 The Source Qualifier Transformation
Lecture 33 The Sequence Generator Transformation
Lecture 34 Classification of Transformation
Lecture 35 The Lookup Transformation
Lecture 36 Types of Caches
Lecture 37 The Update Strategy Transformation
Lecture 38 The Stored Procedure Transformation
Lecture 39 Understanding SCD Types
Lecture 40 Implementing SCD1 Mapping
Lecture 41 Implementing SCD2 Mapping
Lecture 42 Implementing SCD3 Mapping
Section 3: Mastering Informatica PowerCenter 9
Lecture 43 The Course Overview
Lecture 44 Creating Reusable Transformations
Lecture 45 Creating Mapplets
Lecture 46 Working With Debugger
Lecture 47 Target Loan Plan
Lecture 48 Comparing Objects
Lecture 49 Dependencies
Lecture 50 Tracing Level
Lecture 51 Types Of Tasks
Lecture 52 Command task
Lecture 53 Email Task
Lecture 54 Event Task
Lecture 55 Timer Task
Lecture 56 Link Task
Lecture 57 Decision Task
Lecture 58 Assignment Task
Lecture 59 Control Task
Lecture 60 Session Task Properties
Lecture 61 Configuring internal Scheduler
Lecture 62 Reusable Tasks

Lecture 63 Worklets
Lecture 64 Configuring File Lists
Lecture 65 Working with Incremental Aggregation
Lecture 66 Working on Parameter Files
Lecture 67 Performance Optimization
Lecture 68 Partitioning
Lecture 69 Pushdown Optimization
This Learning Path is aimed at technical and non-technical people who aim to make their career using one of the most sought after data warehousing tools in the market
https://www.udemy.com/course/learning-path-complete-roadway-to-informatica-powercenter-9/