5. Using the Workflow Manager Screen – Advanced | Learning Informatica PowerCenter 9.x

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

The assignment task

The assignment task is used to assign a value to user-defined variables in Workflow Manager.

Before you can define a variable in the assignment task, you need to add the variable in Workflow Manager. To add a variable to the Workflow, perform the following steps:

In Workflow Manager, open the workflow for which you wish to define user-defined variables. Navigate to Workflow | Edit | Variables.
Click on the Add a new variable option to add new variables to the workflow, as shown in the preceding screenshot.
A new variable is created, as shown in the preceding screenshot. The new variable that is created is $$NEWVARIABLE1. You can change the name of the variable and its data type.

Creating an assignment task

To create an assignment task in Workflow Manager, follow these steps:

In Workflow Manager, navigate to Task | Create.
From the list of tasks, select Assignment Task and specify the name of the assignment task, which is amt_TASK_NAME. For our reference, we are using the assignment...

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