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.

Related Content you might be interested in

Current Title:

Small book image
Learning Informatica PowerCenter 10.x - Second Edition
Rahul Malewar
Aug, 2017 | 426 pages
No titles found
Table of Contents (20 chapters)
Title Page
Title Page
Credits
Credits
About the Author
About the Author
Acknowledgement
Acknowledgement
About the Reviewer
About the Reviewer
www.PacktPub.com
www.PacktPub.com
Customer Feedback
Customer Feedback
Preface
Preface
Free Chapter
1
Downloading and Extracting Informatica PowerCenter Software
Downloading and Extracting Informatica PowerCenter Software
Downloading the latest version of Informatica PowerCenter - 10.1.0
Extracting the downloaded files - preparing the installable
Informatica installation - the prerequisites
Beginning the installation - installing the server
Getting the graphical interface ready- client installation
Summary
2
Understanding Admin Console
Understanding Admin Console
The Informatica architecture
Informatica services
The Administration Console - configuration
Repository creation - the centralized database for Informatica
Creating the integration service - the path for flow of data
Model Repository Service - a storage place for other developer tools
Informatica users and authentications
Repository Manager - the client configuration
Summary
3
Understanding Designer Screen and its Components
Understanding Designer Screen and its Components
Understanding Designer Interface
Working with Sources
Working with Targets
Feel of data inside Repository - preview
Creating a Database Table
Creating a mapping and using transformation features
Summary
4
The Lifeline of Informatica - Transformations
The Lifeline of Informatica - Transformations
Creating the transformation
Expression transformation
Ports in transformations
Using the expression editor
Aggregator transformation
Sorter transformation
Filter transformation
Router transformation
Rank transformation
Sequence Generator transformation
Joiner transformation
Union transformation
Source Qualifier transformation
Classification of transformations
Lookup transformation
Update Strategy transformation
Normalizer transformation
Stored Procedure transformation
Transaction Control transformation
Types of Lookup cache
Tracing level
Summary
5
Using the Designer Screen - Advanced Features
Using the Designer Screen - Advanced Features
Debug me please - the debugger
Reuse me please - reusable transformation
Managing the constraints - the target load plan
Avoid hardcoding - parameters and variables
Comparing objects
Summary
6
Implementing SCD Using Designer Screen Wizards
Implementing SCD Using Designer Screen Wizards
Types of SCD
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
7
Using the Workflow Manager Screen
Using the Workflow Manager Screen
Using the Workflow Manager
Creating a workflow
Adding a task to the workflow
Working with the Session task and basic properties
Assigning the integration service to the workflow
Deleting a workflow
Trigger - starting a workflow
Working with Connection objects
Summary
8
Learning Various Tasks in Workflow Manager screen
Learning Various Tasks in Workflow Manager screen
Working with tasks
Configuring a task
Session task
Command task
Email Task
Assignment Task
Timer task
Control task
Decision task
Event tasks - Event Wait and Event Raise
Link task
Worklets - Groups of tasks
Summary
9
Advanced Features of Workflow Manager Screen
Advanced Features of Workflow Manager Screen
Schedulers
File list - the indirect way
Incremental Aggregation
Parameter file - parameters and variables
Summary
10
Working with Workflow Monitor - Monitoring the code
Working with Workflow Monitor - Monitoring the code
Using the Workflow Monitor
Connecting the Workflow Manager Screen
Opening previous workflow runs
Running or recovering workflow or task
Stopping or aborting the workflow or task
Status of the workflow and tasks
Viewing 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
11
The Deployment Phase - Using Repository Manager
The Deployment Phase - Using Repository Manager
Using the Repository Manager
Take me to the next stage - Deployment or Migration
Summary
12
Optimization - Performance Tuning
Optimization - Performance Tuning
Bottlenecks
Working on partitioning
Pushdown optimization
Summary

Types of SCD

The various types of SCD are described as follows:

  • Type 1 dimension mapping (SCD1): This keeps only current data and does not maintain historical data.

Note

Use SCD1 mapping when you do not want history of previous data.

  • Type 2 dimension/version number mapping (SCD2): This keeps current as well as historical data in the table. It allows you to insert new records and changed records using a new column (PM_VERSION_NUMBER) by maintaining the version number in the table to track the changes. We use a new column PM_PRIMARYKEY to maintain the history.

Note

Use SCD2 mapping when you want to keep a full history of dimension data, and track the progression of changes using a version number.

  • Consider there is a column LOCATION in the EMPLOYEE table and you wish to track the changes in the location on employees. Consider a record for Employee ID 1001 present in your EMPLOYEE dimension table. Steve was initially working in India and then shifted to USA. We are willing to maintain history on the...
Previous Section
End of Section 2
Next Section