Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Informatica PowerCenter 10.x - Second Edition

By : Rahul Malewar

4.3 (4)

Learning Informatica PowerCenter 10.x

4.3 (4)

By: Rahul Malewar

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

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 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

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 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

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

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

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 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

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

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

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

The Deployment Phase - Using Repository Manager

Using the Repository Manager

Take me to the next stage - Deployment or Migration

Summary

Optimization - Performance Tuning

Optimization - Performance Tuning

Bottlenecks

Working on partitioning

Pushdown optimization

Summary

Using the Designer Screen - Advanced Features

In previous chapters, we developed our skills for using the PowerCenter Designer screen and various transformations present in Informatica.

In this chapter, we will talk about high-level aspects of the PowerCenter Designer screen. Once we are clear about the basics of the Designer screen, we are all set to work on the advanced concepts of PowerCenter Designer. Apart from the basic functionalities of creating mappings, the Designer screen offers multiple utilities to assist you in smoother execution of ETL processing. Some of these functionalities will be regularly used, and some will be rare to you. It is always good to have an understanding of these functionalities to have the upper hand when using the tool.

The topics that will be covered in this chapter are listed as follows:

Debugger
Reusable transformations
Mapplets
Target load...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Informatica PowerCenter 10.x

Search

Your notes and bookmarks