更新时间：2021-07-02 20:56:29
cover
Title Page
Second Edition
Copyright
Learning Informatica PowerCenter 10.x
Credits
About the Author
Acknowledgement
About the Reviewer
www.PacktPub.com
Why subscribe?
Customer Feedback
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Errata
Piracy
Questions
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
Configuring the domain and node
Getting the graphical interface ready- client installation
Summary
Understanding Admin Console
The Informatica architecture
Domain
Node
Informatica services
The service manager
Repository
Repository services
Integration services
Model repository service
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
Understanding Designer Screen and its Components
Understanding Designer Interface
Designer screen components
Working with Sources
Adding new Open Database Connectivity (ODBC) data source
Working with relational database tables - the Import option
Working with flat files - Import option
Working with delimited files
Working with fixed width files
Working with Sources - the Create option
Working with Targets
Working with Target relational database tables - the Import option
Working with Target Flat Files - the Import option
Working with fixed width Files
Working with Target - the Create option
Working with Target - the Copy or Drag-Drop option
Creating Source Definition from Target structure
Feel of data inside Repository - preview
Previewing the source data - flat files
Previewing the Source Data - relational tables
Creating a Database Table
Creating a mapping and using transformation features
The Lifeline of Informatica - Transformations
Creating the transformation
Mapping Designer
Mapplet Designer
Transformation Developer
Expression transformation
Ports in transformations
Using the expression editor
Aggregator transformation
Using Group By
Using Sorted Input
Sorter transformation
Filter transformation
Router transformation
Rank transformation
Group by Ranking
Rank Index
Sequence Generator transformation
Ports of Sequence Generator transformation
Properties of Sequence Generator transformation
Joiner transformation
Master and Detail Pipeline
Join condition
Join type
Normal join
Full join
Master Outer join
Detail Outer join
Union transformation
