Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Learning Informatica PowerCenter 9.x
  • Table Of Contents Toc
Learning Informatica PowerCenter 9.x

Learning Informatica PowerCenter 9.x

By : Rahul Malewar
4 (10)
Buy this Book
close
close
Learning Informatica PowerCenter 9.x

Learning Informatica PowerCenter 9.x

4 (10)
By: Rahul Malewar
Buy this Book

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.
Table of Contents (12 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Starting the Development Phase – Using the Designer Screen Basics
Icon
1. Starting the Development Phase – Using the Designer Screen Basics
Icon
Informatica PowerCenter Designer
Icon
The Designer screen's components
Icon
Summary
2
2. Using the Designer Screen – Advanced
Icon
2. Using the Designer Screen – Advanced
Icon
Debug me please – the debugger
Icon
Reuse me please – reusable transformation
Icon
Managing constraints – the target load plan
Icon
I hate hardcoding – parameters and variables
Icon
Comparing objects
Icon
Summary
3
3. Implementing SCD – Using Designer Screen Wizards
Icon
3. Implementing SCD – Using Designer Screen Wizards
Icon
SCD1 – I hate history!
Icon
SCD2 (version number) – I need my ancestors!
Icon
SCD2 (flag) – flag the history
Icon
SCD2 (date range) – marking the dates
Icon
SCD3 – store something, if not everything!
Icon
Summary
4
4. Finishing the Development – Using the Workflow Manager Screen Basics
Icon
4. Finishing the Development – Using the Workflow Manager Screen Basics
Icon
Using Workflow Manager
Icon
Creating a workflow
Icon
Adding tasks in a workflow
Icon
Working with the session task – basic properties
Icon
Connecting the tasks – links
Icon
Assigning Integration Service to a workflow
Icon
Deleting a workflow
Icon
Trigger – starting a workflow
Icon
Working with connection objects
Icon
Summary
5
5. Using the Workflow Manager Screen – Advanced
Icon
5. Using the Workflow Manager Screen – Advanced
Icon
Working with tasks
Icon
Configuring a task
Icon
The session task
Icon
The command task
Icon
The e-mail task
Icon
The assignment task
Icon
The timer task
Icon
The control task
Icon
The decision task
Icon
Event tasks – event wait and event raise
Icon
The link task
Icon
Worklets – groups of tasks
Icon
Schedulers
Icon
File List – the indirect way
Icon
Incremental aggregation
Icon
The parameter file – parameters and variables
Icon
Summary
6
6. Monitoring Your Code – Using the Workflow Monitor Screen
Icon
6. Monitoring Your Code – Using the Workflow Monitor Screen
Icon
Using Workflow Monitor
Icon
Connecting to the Workflow Manager screen
Icon
Opening previous workflow runs
Icon
Running or recovering workflows or tasks
Icon
Stopping or aborting the workflow or task
Icon
The status of workflows and tasks
Icon
Viewing the session log and workflow log
Icon
Working with the workflow log
Icon
Working with the session log
Icon
Viewing workflow run properties
Icon
Viewing session run properties
Icon
Common errors
Icon
Summary
7
7. The Lifeline of Informatica – Transformations
Icon
7. The Lifeline of Informatica – Transformations
Icon
Creating the transformation
Icon
The Expression transformation
Icon
Ports in transformations
Icon
Using the expression editor
Icon
The Aggregator transformation
Icon
The Sorter transformation
Icon
The Filter transformation
Icon
The Router transformation
Icon
The Rank transformation
Icon
The Sequence Generator transformation
Icon
The Joiner transformation
Icon
Union transformation
Icon
Source Qualifier transformation
Icon
Classification of transformations
Icon
The Lookup transformation
Icon
The Update Strategy transformation
Icon
The Normalizer transformation
Icon
The Stored Procedure transformation
Icon
Transaction Control transformations
Icon
Types of lookup cache
Icon
Tracing levels
Icon
Summary
8
8. The Deployment Phase – Using Repository Manager
Icon
8. The Deployment Phase – Using Repository Manager
Icon
Using Repository Manager
Icon
Configuring the client tools
Icon
Take me to next stage – deployment or migration
Icon
Summary
9
9. Optimization – Performance Tuning
chevron up
Icon
9. Optimization – Performance Tuning
Icon
Bottlenecks
Icon
Working on partitioning
Icon
Pushdown optimization
Icon
Summary
10
A. Installing Informatica and Using Informatica Administration Console
Icon
A. Installing Informatica and Using Informatica Administration Console
Icon
The Informatica architecture
Icon
Informatica installation – the prerequisites
Icon
Downloading the Informatica PowerCenter software
Icon
Extracting the package – opening the installable
Icon
Starting the installation
11
Index
Icon
Index

Pushdown optimization

Pushdown optimization is a concept using which you can push the transformation logic on the source or target database side. When you have a source as the database table, you can make use of a SQL override to remove the logic written in the transformation. When you use the SQL override, the session performance is enhanced, as processing the data at a database level is faster compared to processing the data in Informatica. You cannot remove all the transformations from the mapping. The part of transformation logic that can be pushed at the source or target level is referred to as pushdown optimization.

Consider that you have a mapping with a sequence indicated as follows:

Source - Source Qualifier - Filter - Sorter - Aggregator - Expression - Lookup - Rank - Target.

In Filter transformations, we are filtering the data in a particular location. In Sorter transformations, the data is sorted in a particular department ID. In the Aggregator, we are grouping the data in the department...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Learning Informatica PowerCenter 9.x
End of Section 9
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon