Learning Informatica PowerCenter 9.x
Год издания: 2014
Автор: Rahul Malewar
Издательство: Packt Publishing
ISBN: 9781782176480
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 443
Описание: Informatica PowerCenter provides the perfect platform to utilize and leverage business data. It allows you to easily, conveniently, and efficiently work on different types of data.
This book covers functionality such as creating/importing source and target, identifying errors, and debugging your mapping through a series of comprehensive tutorials. Besides learning about types of Slowly Changing Dimensions (SCDs), you will learn to create and link workflows. As you progress, exhaustive knowledge of transformations and techniques to create folders, migrate code, and optimize system performance will be explored in detail.
The step-by-step approach and adoption of real-time scenarios will guide you through effectively accessing all core functionalities offered by Informatica PowerCenter.
Примеры страниц Оглавление
1: Starting the Development Phase – Using the Designer Screen Basics
Informatica PowerCenter Designer
The Designer screen's components
2: 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
3: 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!
4: 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
5: 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
File List – the indirect way
Incremental aggregation
The parameter file – parameters and variables
6: 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
7: 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
8: The Deployment Phase – Using Repository Manager
Using Repository Manager
Configuring the client tools
Take me to next stage – deployment or migration
9: Optimization – Performance Tuning
Working on partitioning
Pushdown optimization

If you like the topic, please click share to help develop our site.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 24 MB Download Torrent

Login using:

Similar topics

Hans-Jürgen Schönig - Mastering PostgreSQL 10 [2018, PDF, ENG]
 2 MB   0 | 0   16-Aug-18 15:10   11

Current time is: 21-Feb 17:03 :: All times are UTC + 3