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

SCD1 - I hate history!

To implement SCD1 using wizard, follow these steps:

  1. In the Designer, go to Tools | Mapping Designer | Mapping | Wizard | Slowly Changing Dimensions as shown in the following screenshot:
  1. A new window will pop up asking the name (m_SCD1) of the new SCD mapping. Select Type 1 Dimension - Keep most recent values in the target as we are implementing SCD1. Click on Next:
  1. The next screen will ask you to select the source. Select a source from the drop-down. All the sources present in your repository will be listed in this drop-down list. We are using EMP_FILE.txt as the source file for our reference. Also, specify the name of the target you wish to create. We will name the target EMPLOYEE_SCD1 for our reference in this book. Click on Next:
  1. In the next window, select EMPLOYEE_ID as Logical Key Field. This specifies which column will be used to check the existence of data in the target. Make sure the column you use is the key column of the source.
    • Also, add LOCATION under Fields...
Previous Section
End of Section 3
Next Section