book

Learning Informatica PowerCenter 9.x

by Rahul Malewar

December 2014

Intermediate to advanced

362 pages

8h 12m

English

Packt Publishing

Read now

Unlock full access

Support files, eBooks, discount offers, and moreWhy subscribe?Free access for Packt account holdersInstant updates on new Packt books
What this book covers

ErrataPiracyQuestions
Informatica PowerCenter Designer
Working with sourcesAdding a new ODBC data sourceWorking with relational database tables – the Import optionWorking with flat files – the Import optionWorking with delimited filesWorking with fixed-width filesWorking with sources – the Create optionWorking with targetsWorking with target relational database tables – the Import optionWorking with target flat files – the Import optionWorking with delimited filesWorking with fixed-width filesWorking with the target – the Create optionWorking with the target – the Copy optionA feel of the data inside the repository – a previewPreviewing the source data – flat filesPreviewing the source data – a relational tableCreating a database tableThe skeleton – a mapping
Debug me please – the debugger
Using Transformation DeveloperMaking existing transformation reusableMapplet
SCD1 – I hate history!
Using Workflow Manager
Creating a workflow manuallyCreating a workflow automatically
Adding tasks to the workflow directlyCreating nonreusable tasks – Task DeveloperAdding tasks to the workflow – Task Developer
Running the complete workflowRunning a part of the workflowRunning a task
Creating a connection objectConfiguring a relational database
Working with tasks
Tabs of the session taskCreating a session task
Creating a command task
Creating an e-mail task
Creating an assignment task
Creating a timer task
Creating a control task
Creating a decision task
Creating an event (wait/raise) task
Creating a link task
Creating a worklet
Defining session-level variablesDefining workflow-level variablesDefining mapping-level variablesCreating the parameter fileMentioning the parameter file at the workflow levelMentioning the parameter file at the session level
Using Workflow Monitor
Properties of task detailsProperties of source/target statistics
Creating the transformationMapping DesignerMapplet DesignerTransformation Developer
Using Group ByUsing Sorted Input
Group by rankingRank index
Ports of the Sequence Generator transformationProperties of the Sequence Generator transformation
Master and detail pipelineJoin conditionJoin typeNormal joinFull joinMaster outer joinDetail outer join
Viewing the default queryOverriding the default queryUsing the WHERE clauseJoining the source dataSorting the dataSelecting distinct records
Active and passiveConnected and unconnected
Creating a Lookup transformationConfiguring the Lookup transformationSetting up the Lookup transformationLookup portsLookup queriesUnconnected Lookup transformationsLookup transformation properties
Configuring the Normalizer transformation – ports
Importing Stored Procedure transformationsCreating Stored Procedure transformationsUsing Stored Procedure transformations in the mappingConnected Stored Procedure transformationsUnconnected Stored Procedure transformations
Building the cache – sequential or concurrentSequential cacheConcurrent cachePersistent cache – the permanent oneSharing cache – named or unnamedSharing unnamed cacheSharing named cacheModifying cache – static or dynamicStatic cacheDynamic cache
Using Repository Manager
Export/ImportMigrating from the designerMigrating from Repository ManagerThe Copy/Paste featureThe drag-and-drop feature
BottlenecksFinding the target bottleneckUsing thread statisticsConfiguring the sample target loadEliminating the target bottleneckMinimizing the target table deadlocksDrop indexes and constraintsIncreasing the checkpoint intervalUsing an external loaderIncreasing the network packet sizeUsing the bulk loadFinding the source bottleneckUsing thread statisticsTest mappingUsing a Filter transformationChecking the database queryEliminating the source bottleneckIncreasing the network packet sizeOptimizing the database queryFinding the mapping bottleneckUsing thread statisticsUsing a Filter transformationEliminating the mapping bottleneckUsing a single pass mappingAvoiding data type conversionsUnchecking unnecessary portsProcessing the numeric dataUsing operators instead of functionsUsing decode in place of multiple IIF functionsThe tracing levelUsing variable portsOptimizing Filter transformationsOptimizing the Aggregator transformationOptimizing the Joiner transformationOptimizing Lookup transformationsEliminating the session bottleneckOptimizing the commit intervalThe buffer memoryPerformance dataEliminating the system bottleneck
Partitioning propertiesPartition pointsThe number of partitionsPartition types
The Informatica architectureDomainNodeInformatica servicesThe service managerRepositoryRepository servicesIntegration Services
Installing the serverConfiguring the domain and nodeClient installation – the graphical interface toolsThe administration console – configurationRepository creation – the first centralized database for InformaticaCreating the Integration Service – the path for dataInformatica user and authenticationsRepository Manager – the client configuration

Overview

Master the essentials of Informatica PowerCenter 9.x with this comprehensive guide. Whether you are new to the platform or an experienced user, this book provides the knowledge and techniques needed to extract, integrate, and manage data effectively across diverse systems. By learning key functionalities and advanced techniques, you'll become proficient in creating and optimizing data integration workflows.

What this Book will help me do

Install, configure, and customize Informatica PowerCenter to suit your project requirements.
Understand graphical interfaces such as the Designer and Workflow Manager for effective development.
Implement data warehousing concepts like Slowly Changing Dimensions (SCDs) using Informatica tools.
Optimize data integration workflows through performance tuning and advanced debugging techniques.
Execute seamless migrations of components across environments using repository management features.

Author(s)

Rahul Malewar is an experienced data integration specialist with a strong background in Informatica and data warehousing. With years of practical experience in implementing and deploying complex Informatica solutions, Rahul brings technical expertise combined with a clear and accessible teaching style. His books and courses are widely recognized for helping readers efficiently tackle real-world data challenges.

Who is it for?

This book is best suited for IT professionals, data analysts, and developers interested in mastering data integration concepts and tools through Informatica PowerCenter. If you work in data warehousing or are stepping into the field, this book provides essential knowledge. Beginner users will find step-by-step guidance, while experienced professionals will deepen their expertise. Prior knowledge in programming and data warehousing is beneficial.