Book Image

Learning Informatica PowerCenter 9.x

By : Rahul Malewar
Book Image

Learning Informatica PowerCenter 9.x

By: Rahul Malewar

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Learning Informatica PowerCenter 9.x
Rahul Malewar
Dec, 2014 | 362 pages
Small book image
Business Intelligence Career Master Plan
Danny Moncada | Eduardo Chavez
Aug, 2023 | 284 pages
Small book image
Mastering NLP from Foundations to LLMs
Meysam Ghaffari | Lior Gazit
Apr, 2024 | 340 pages
Small book image
Principles of Data Science
Sinan Ozdemir
Jan, 2024 | 326 pages
Table of Contents (18 chapters)
Learning Informatica PowerCenter 9.x
Learning Informatica PowerCenter 9.x
Credits
Credits
About the Author
About the Author
Acknowledgments
Acknowledgments
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Starting the Development Phase – Using the Designer Screen Basics
Starting the Development Phase – Using the Designer Screen Basics
Informatica PowerCenter Designer
The Designer screen's components
Summary
2
Using the Designer Screen – Advanced
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
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
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
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
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
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
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
Optimization – Performance Tuning
Bottlenecks
Working on partitioning
Pushdown optimization
Summary
Installing Informatica and Using Informatica Administration Console
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 Aggregator transformation

The Aggregator transformation is used for calculations using aggregate functions in a column as opposed to the Expression transformation that is used for row-wise manipulation.

You can use aggregate functions, such as SUM, AVG, MAX, and MIN, in the Aggregator transformation.

Use the EMPLOYEE Oracle table as the source and get the sum of the salaries of all employees in the target.

Perform the following steps to implement the functionality:

  1. Import the source using the EMPLOYEE Oracle table in Source Analyzer and create the TGT_TOTAL_SALARY target in Target Designer.

  2. Create the m_AGG_TOTAL_SALARY mapping and drag the source and target from the navigator to the workspace. Create the Aggregator transformation with the AGG_TOTAL_SAL name.

  3. As we need to calculate TOTAL_SALARY, drag only the SALARY column from the source qualifier to the Aggregator transformation.

  4. Add a new TOTAL_SALARY column to the Aggregator transformation to calculate the total salary, as shown in the...

Previous Section
End of Section 6
Next Section