Learning Informatica PowerCenter 9.x

Learn the art of extracting data from disparate systems, integrating it using the leading data integration platform, and creating intelligent data centers for your business

About This Book

• Learn the functionalities of each component in the Informatica PowerCenter tool and deploy them to accomplish executive reporting using logical data stores
• Learn the core features of Informatica PowerCenter tool along with its administration and architectural aspects
• Develop skills to extract data and efficiently utilize it with the help of world’s most widely used integration tool, and make a promising career in Informatica PowerCenter

Who This Book Is For

If you wish to deploy Informatica in enterprise environments and make a career in data warehousing, then this book is for you. Whether you are a developer who’s new to Informatica or an experienced professional, you will learn all the features of Informatica. Basic knowledge of programming and data warehouse concepts is essential.

In Detail

Informatica PowerCenter provides the perfect platform to utilize and leverage business data. It allows you to easily, conveniently, and efficiently work on different types of data.

This book covers functionality such as creating/importing source and target, identifying errors, and debugging your mapping through a series of comprehensive tutorials. Besides learning about types of Slowly Changing Dimensions (SCDs), you will learn to create and link workflows. As you progress, exhaustive knowledge of transformations and techniques to create folders, migrate code, and optimize system performance will be explored in detail.

The step-by-step approach and adoption of real-time scenarios will guide you through effectively accessing all core functionalities offered by Informatica PowerCenter.

Table of Contents

Chapter 1: Starting the Development Phase – Using the Designer Screen Basics
Chapter 2: Using the Designer Screen – Advanced
Chapter 3: Implementing SCD – Using Designer Screen Wizards
Chapter 4: Finishing the Development – Using the Workflow Manager Screen Basics
Chapter 5: Using the Workflow Manager Screen – Advanced
Chapter 6: Monitoring Your Code – Using the Workflow Monitor Screen
Chapter 7: The Lifeline of Informatica – Transformations
Chapter 8: The Deployment Phase – Using Repository Manager
Chapter 9: Optimization – Performance Tuning
Appendix: Installing Informatica and Using Informatica Administration Console