Book Overview & Buying
Table Of Contents

Learning Informatica PowerCenter 10.x - Second Edition

By : Rahul Malewar

4.3 (4)

Buy this Book

Learning Informatica PowerCenter 10.x

4.3 (4)

By: Rahul Malewar

Buy this Book

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.

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Free Chapter

Downloading and Extracting Informatica PowerCenter Software

Downloading the latest version of Informatica PowerCenter - 10.1.0

Extracting the downloaded files - preparing the installable

Informatica installation - the prerequisites

Beginning the installation - installing the server

Getting the graphical interface ready- client installation

Summary

Understanding Admin Console

The Informatica architecture

Informatica services

The Administration Console - configuration

Repository creation - the centralized database for Informatica

Creating the integration service - the path for flow of data

Model Repository Service - a storage place for other developer tools

Informatica users and authentications

Repository Manager - the client configuration

Summary

Understanding Designer Screen and its Components

Understanding Designer Interface

Working with Sources

Working with Targets

Feel of data inside Repository - preview

Creating a Database Table

Creating a mapping and using transformation features

Summary

The Lifeline of Informatica - Transformations

Creating the transformation

Expression transformation

Ports in transformations

Using the expression editor

Aggregator transformation

Sorter transformation

Filter transformation

Router transformation

Rank transformation

Sequence Generator transformation

Joiner transformation

Union transformation

Source Qualifier transformation

Classification of transformations

Lookup transformation

Update Strategy transformation

Normalizer transformation

Stored Procedure transformation

Transaction Control transformation

Types of Lookup cache

Tracing level

Summary

Using the Designer Screen - Advanced Features

Debug me please - the debugger

Reuse me please - reusable transformation

Managing the constraints - the target load plan

Avoid hardcoding - parameters and variables

Comparing objects

Summary

Implementing SCD Using Designer Screen Wizards

Types of SCD

SCD1 - I hate history!

SCD2 (version number) - I need my ancestors!

SCD2 (flag) - flag the history

SCD2 (date range) - marking the dates

SCD3 - store something if not everything

Summary

Using the Workflow Manager Screen

Using the Workflow Manager

Creating a workflow

Adding a task to the workflow

Working with the Session task and basic properties

Assigning the integration service to the workflow

Deleting a workflow

Trigger - starting a workflow

Working with Connection objects

Summary

Learning Various Tasks in Workflow Manager screen

Working with tasks

Configuring a task

Session task

Command task

Email Task

Assignment Task

Timer task

Control task

Decision task

Event tasks - Event Wait and Event Raise

Link task

Worklets - Groups of tasks

Summary

Advanced Features of Workflow Manager Screen

Schedulers

File list - the indirect way

Incremental Aggregation

Parameter file - parameters and variables

Summary

Working with Workflow Monitor - Monitoring the code

Using the Workflow Monitor

Connecting the Workflow Manager Screen

Opening previous workflow runs

Running or recovering workflow or task

Stopping or aborting the workflow or task

Status of the workflow and tasks

Viewing session log and workflow log

Working with the workflow log

Working with the session Log

Viewing workflow run properties

Viewing session run properties

Common Errors

Summary

The Deployment Phase - Using Repository Manager

Using the Repository Manager

Take me to the next stage - Deployment or Migration

Summary

Optimization - Performance Tuning

Bottlenecks

Working on partitioning

Pushdown optimization

Summary

Expression transformation

Expression transformation is used for row-wise manipulation. For any type of manipulation you wish to do on an individual record, use expression transformation. Expression transformation accepts row-wise data, manipulates it, and passes to the target. The transformation receives the data from the input port and sends the data out from the output ports.

Use the expression transformation for any row-wise calculation, for instance, if you want to concatenate the names, calculate the total salary and convert in upper case, and so on. To understand functionality of expression transformation, let's consider the following scenario:

Scenario for expression transformation: Using the flat file we created in Chapter 3, Understanding Designer Screen and its Components as the source, concatenate FIRST_NAME and LAST_NAME to get FULL_NAME, and get TOTAL_SALARY...