In lines with the release of book Learning Informatica PowerCenter 10.1.0, we have tried to present a technology in its most simple form to the readers. We have tried to explain every aspect for new learners of Informatica. Also, we have covered everything for the users of the older version to upgrade to the latest version. This book covers everything, from basics, such as downloading, extraction, and installation, to working on the client tools and then high-level aspects such as scheduling, migration, performance optimization, and so on in simple words. The use of this book will eliminate the need to browse multiple blogs available on the internet that talk about Informatica tool. What you get in this book is everything from start to end; using this book, you can develop and deploy end-to-end projects on Informatica. In this book, you will get the step-by-step procedure for every aspect of Informatica Power Center Tool. Informatica Corporation (Informatica), a multimillion dollar company incorporated in February 1993, is an independent provider of enterprise data integration and data quality software and services. The company enables a variety of complex enterprise data integration products, which include Power Center, Power Exchange, enterprise data integration, data quality, master data management, business-to-business (B2B) data exchange, application information life cycle management, complex event processing, ultra messaging, and cloud data integration. You are going to learn the latest version of Power Center tool of Informatica in this book. Power Center is the most widely used tool of Informatica across the globe for various data integration processes. Informatica Power Center tool helps integration of data from almost any business system in almost any format. This flexibility of Power Center to handle almost any data makes it the most widely used tool in the data integration world. While writing this book, we kept in mind the importance of live practical exposure of the graphical interface of the tool to the audience, and hence, you will notice a lot of screenshots illustrating the steps to help you understand and follow the process. We have added images depicting every step that you can follow and practice on your own in your machine. You will also get all the screenshots of the installation procedure, which is totally changed from its previous version. We have also provided a lot of real-life examples to help you understand the development aspects in detail. Each concept in the book is self-explanatory, with the precise screenshot of each step. The arrangement of chapters is such that by the end of the book, you will have complete knowledge--from installation to development skills. Let's take small gist of the contents of the book.
-
Book Overview & Buying
-
Table Of Contents
Learning Informatica PowerCenter 10.x - Second Edition
By :
Learning Informatica PowerCenter 10.x
By:
Overview of this book
Informatica PowerCenter is an industry-leading ETL tool, known for its accelerated data extraction, transformation, and data management strategies. This book will be your quick guide to exploring Informatica PowerCenter’s powerful features such as working on sources, targets, transformations, performance optimization, scheduling, deploying for processing, and managing your data at speed.
First, you’ll learn how to install and configure tools. You will learn to implement various data warehouse and ETL concepts, and use PowerCenter 10.x components to build mappings, tasks, workflows, and so on. You will come across features such as transformations, SCD, XML processing, partitioning, constraint-based loading, Incremental aggregation, and many more. Moreover, you’ll also learn to deliver powerful visualizations for data profiling using the advanced monitoring dashboard functionality offered by the new version.
Using data transformation technique, performance tuning, and the many new advanced features, this book will help you understand and process data for training or production purposes. The step-by-step approach and adoption of real-time scenarios will guide you through effectively accessing all core functionalities offered by Informatica PowerCenter version 10.x.
Table of Contents (13 chapters)
Preface
Downloading and Extracting Informatica PowerCenter Software
Understanding Admin Console
Understanding Designer Screen and its Components
The Lifeline of Informatica - Transformations
Using the Designer Screen - Advanced Features
Implementing SCD Using Designer Screen Wizards
Using the Workflow Manager Screen
Learning Various Tasks in Workflow Manager screen
Advanced Features of Workflow Manager Screen
Working with Workflow Monitor - Monitoring the code
The Deployment Phase - Using Repository Manager
Optimization - Performance Tuning