Learning Informatica PowerCenter 10.x - Second Edition电子书

Title Page

Second Edition

Copyright

Learning Informatica PowerCenter 10.x

Second Edition

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

Summary

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 delimited files

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

Summary

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

Source Qualifier transformation

Viewing default query

Overriding default query

Using the WHERE clause

Joining Source Data

Sorting the data

Selecting distinct records

Classification of transformations

Active and Passive

Connected and Unconnected

Lookup transformation

Creating the Lookup transformation

Configuring the Lookup transformation

Configuring the Lookup transformation

Lookup ports

Lookup query

Unconnected Lookup transformation

Lookup transformation properties

Update Strategy transformation

Normalizer transformation

Configuring Normalizer transformation - ports

Stored Procedure transformation

Importing Stored Procedure transformation

Creating Stored Procedure transformation

Using Stored Procedure transformation in Mapping

Connected Stored Procedure transformation

Unconnected Stored Procedure transformation

Transaction Control transformation

Types of Lookup cache

Building the Cache - Sequential or Concurrent

Sequential cache

Concurrent cache

Persistent cache - the permanent one

Sharing the cache - named or unnamed

Sharing unnamed cache

Sharing named cache

Modifying cache - static or dynamic

Static cache

Dynamic cache

Tracing level

Summary

Using the Designer Screen - Advanced Features

Debug me please - the debugger

Reuse me please - reusable transformation

Using Transformation Developer

Making an existing transformation reusable

Mapplet

Managing the constraints - the target load plan

Avoid hardcoding - parameters and variables

Comparing objects

Summary

Implementing SCD Using Designer Screen Wizards

Types of SCD

SCD1

SCD2 - Version number

SCD2 - FLAG

SCD2 - Date range

SCD3

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

Using the Workflow Manager Screen

Using the Workflow Manager

Creating a workflow

Creating a workflow manually

Creating a workflow automatically

Adding a task to the workflow

Adding tasks to the workflow directly

Adding tasks to the workflow by task developer

Adding tasks to the workflow by task developer

Working with the Session task and basic properties

Assigning the integration service to the workflow

Deleting a workflow

Trigger - starting a workflow

Running a complete workflow

Running a part of the workflow

Running a task

Working with Connection objects

Creating a Connection object

Configuring the Relational Database

Summary

Learning Various Tasks in Workflow Manager screen

Working with tasks

Configuring a task

Session task

Tabs of a session task

Creating a Session Task

Command task

Creating a Command task

Email Task

Creating an Email Task

Assignment Task

Creating an Assignment Task

Timer task

Creating a Timer Task

Control task

Creating a Control task

Decision task

Creating a Decision task

Event tasks - Event Wait and Event Raise

Creating an Event (Wait/Raise) task

Link task

Creating a link task

Worklets - Groups of tasks

Creating a Worklet

Summary

Advanced Features of Workflow Manager Screen

Schedulers

File list - the indirect way

Incremental Aggregation

Parameter file - parameters and variables

Defining session-level variables

Defining workflow-level variables

Defining mapping-level variables

Creating a parameter file

Mentioning the Parameter file at the workflow level

Mentioning the Parameter file at the session level

Summary

Working with Workflow Monitor - Monitoring the code

Using the Workflow Monitor

Connecting the Workflow Manager Screen

Opening previous workflow runs

Running or recovering workflow or task

Stopping or aborting the workflow or task

Status of the workflow and tasks

Viewing session log and workflow log

Working with the workflow log

Working with the session Log

Viewing workflow run properties

Viewing session run properties

Task detail properties

Source/target statistics properties

Common Errors

Summary

The Deployment Phase - Using Repository Manager

Using the Repository Manager

Take me to the next stage - Deployment or Migration

Export/Import

Migrating from Designer

Migrating from Repository Manager

Copy/Paste

Drag/Drop

Summary

Optimization - Performance Tuning

Bottlenecks

Finding the target bottleneck

Using thread statistics

Configuring the sample target load

Eliminating the target bottleneck

Minimizing target table deadlocks

Dropping indexes and constraints

Increasing the checkpoint interval

Using an external loader

Increasing the network packet size

Using bulk load

Finding the source bottleneck

Using thread statistics

Test mapping

Using filter transformation

Checking the database query

Eliminating the source bottleneck

Increasing the network packet size

Optimizing the database query

Finding the mapping bottleneck

Using thread statistics

Using filter transformation

Eliminating the mapping bottleneck

Using single pass mapping

Avoiding data type conversions

Unchecking unnecessary ports

Processing numeric data

Using operators instead of functions

Using Decode in place of multiple IIF

Tracing level

Using variable ports

Optimizing filter transformation

Optimizing Aggregator transformation

Optimizing joiner transformation

Optimizing lookup transformation

Eliminating the session bottleneck

Optimizing the commit interval

Buffer memory

Performance data

Eliminating the system bottleneck

Working on partitioning

Partitioning properties

Partition points

Number of partitions

Partition types

Pushdown optimization

Summary