Book Image

Learning Informatica PowerCenter 10.x - Second Edition

By : Rahul Malewar
Book Image

Learning Informatica PowerCenter 10.x - Second Edition

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.
Table of Contents (20 chapters)
Title Page
Credits
About the Author
Acknowledgement
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Status of the workflow and tasks


Various statuses possible for the workflow and tasks are shown here:

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 executing 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 process of stopping the workflow after manual selection

Aborted

Both

The workflow has been aborted manually

Aborting

Both

The integration service is in process of aborting the workflow after manual selection

Disabled

Both

You have manually selected to disable the Workflow or task

Suspended

Workflow only

The workflow will show a suspended status because of the failure of the task; this status is available only if you selected Suspend on error.

Suspending

Workflow only

The integration...