Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning Informatica PowerCenter 9.x

By : Rahul Malewar

4 (10)

Learning Informatica PowerCenter 9.x

4 (10)

By: Rahul Malewar

Overview of this book

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.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Starting the Development Phase – Using the Designer Screen Basics

1. Starting the Development Phase – Using the Designer Screen Basics

Informatica PowerCenter Designer

The Designer screen's components

Summary

2. Using the Designer Screen – Advanced

2. Using the Designer Screen – Advanced

Debug me please – the debugger

Reuse me please – reusable transformation

Managing constraints – the target load plan

I hate hardcoding – parameters and variables

Comparing objects

Summary

3. Implementing SCD – Using Designer Screen Wizards

3. Implementing SCD – Using Designer Screen Wizards

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

4. Finishing the Development – Using the Workflow Manager Screen Basics

4. Finishing the Development – Using the Workflow Manager Screen Basics

Using Workflow Manager

Creating a workflow

Adding tasks in a workflow

Working with the session task – basic properties

Connecting the tasks – links

Assigning Integration Service to a workflow

Deleting a workflow

Trigger – starting a workflow

Working with connection objects

Summary

5. Using the Workflow Manager Screen – Advanced

5. Using the Workflow Manager Screen – Advanced

Working with tasks

Configuring a task

The session task

The command task

The e-mail task

The assignment task

The timer task

The control task

The decision task

Event tasks – event wait and event raise

The link task

Worklets – groups of tasks

Schedulers

File List – the indirect way

Incremental aggregation

The parameter file – parameters and variables

Summary

6. Monitoring Your Code – Using the Workflow Monitor Screen

6. Monitoring Your Code – Using the Workflow Monitor Screen

Using Workflow Monitor

Connecting to the Workflow Manager screen

Opening previous workflow runs

Running or recovering workflows or tasks

Stopping or aborting the workflow or task

The status of workflows and tasks

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

7. The Lifeline of Informatica – Transformations

7. The Lifeline of Informatica – Transformations

Creating the transformation

The Expression transformation

Ports in transformations

Using the expression editor

The Aggregator transformation

The Sorter transformation

The Filter transformation

The Router transformation

The Rank transformation

The Sequence Generator transformation

The Joiner transformation

Union transformation

Source Qualifier transformation

Classification of transformations

The Lookup transformation

The Update Strategy transformation

The Normalizer transformation

The Stored Procedure transformation

Transaction Control transformations

Types of lookup cache

Tracing levels

Summary

8. The Deployment Phase – Using Repository Manager

8. The Deployment Phase – Using Repository Manager

Using Repository Manager

Configuring the client tools

Take me to next stage – deployment or migration

Summary

9. Optimization – Performance Tuning

9. Optimization – Performance Tuning

Bottlenecks

Working on partitioning

Pushdown optimization

Summary

A. Installing Informatica and Using Informatica Administration Console

A. Installing Informatica and Using Informatica Administration Console

The Informatica architecture

Informatica installation – the prerequisites

Downloading the Informatica PowerCenter software

Extracting the package – opening the installable

Starting the installation

Index

Index

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "We are using HR as our user for making the connection."

A block of code is set as follows:

STEVE 1000 2000 3000 4000
JAMES 2000 2500 3000 3500
ANDY 4000 4000 4000 4000

Any command-line input or output is written as follows:

IIF( ISNULL (JOB_ID), NEXTVAL, JOB_ID)

New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "To open the PowerCenter Designer screen, navigate to Start | All Programs | Informatica 9.5.1 | Client | Power Center Client | Designer."

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.

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 9.x

Search

Your notes and bookmarks