6. Monitoring Your Code – Using the Workflow Monitor Screen | Learning Informatica PowerCenter 9.x

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

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

Customer Reviews

4 (10)

5 star

70%

4 star

0%

3 star

10%

2 star

0%

1 star

20%

Viewing session run properties

Similar to workflow run properties, Informatica PowerCenter Workflow Monitor shows you the session-level run properties. To open the session run properties, right-click on the session and select Get Run Properties.

The session-level run properties section will appear in the bottom-right section of the monitor screen.

Properties of task details

Task details under session run properties are shown in the following screenshot:

The various options under Task Details of the session run properties are as follows:

Properties	Description
Instance Name	This indicates the name of the session.
Task Type	This indicates the type of task. In this case, it is Session.
Integration Service Name	This indicates the name of Integration Services used to run the session.
Node(s)	This indicates the nodes on which the session is running.
Start Time	This indicates the start time of the session.
End Time	This indicates the end time of the session.
Recovery Time...

Visually different images

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