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%

The status of workflows and tasks

Various statuses possible for workflows and tasks are as follows:

Status	Status for Workflow/Task	Description
Succeeded	Both	The process is completed successfully
Failed	Both	The process failed due to some error
Running	Both	The process is getting executed currently
Preparing to Run	Workflow only	The process is waiting for Integration Service to run the workflow
Scheduled	Workflow only	The workflow is scheduled to run in the future
Stopped	Both	The workflow has been stopped manually
Stopping	Both	The Integration Service is in the process of stopping the workflow after manual selection
Aborted	Both	The workflow has been aborted manually
Aborting	Both	The Integration Service is in the process of aborting the workflow after manual selection
Disabled	Both	You manually selected to disable the workflow or task
Suspended	Workflow only	The workflow will show the suspended status because of the failure of the task. This status is...

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