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 10.x
  • Table Of Contents Toc
Learning Informatica PowerCenter 10.x

Learning Informatica PowerCenter 10.x - Second Edition

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

Learning Informatica PowerCenter 10.x

4.3 (4)
By: Rahul Malewar
Buy this Book

Overview of this book

Informatica PowerCenter is an industry-leading ETL tool, known for its accelerated data extraction, transformation, and data management strategies. This book will be your quick guide to exploring Informatica PowerCenter’s powerful features such as working on sources, targets, transformations, performance optimization, scheduling, deploying for processing, and managing your data at speed. First, you’ll learn how to install and configure tools. You will learn to implement various data warehouse and ETL concepts, and use PowerCenter 10.x components to build mappings, tasks, workflows, and so on. You will come across features such as transformations, SCD, XML processing, partitioning, constraint-based loading, Incremental aggregation, and many more. Moreover, you’ll also learn to deliver powerful visualizations for data profiling using the advanced monitoring dashboard functionality offered by the new version. Using data transformation technique, performance tuning, and the many new advanced features, this book will help you understand and process data for training or production purposes. The step-by-step approach and adoption of real-time scenarios will guide you through effectively accessing all core functionalities offered by Informatica PowerCenter version 10.x.
Table of Contents (13 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
Lock Free Chapter
1
Downloading and Extracting Informatica PowerCenter Software
Icon
Downloading and Extracting Informatica PowerCenter Software
Icon
Downloading the latest version of Informatica PowerCenter - 10.1.0
Icon
Extracting the downloaded files - preparing the installable
Icon
Informatica installation - the prerequisites
Icon
Beginning the installation - installing the server
Icon
Getting the graphical interface ready- client installation
Icon
Summary
2
Understanding Admin Console
Icon
Understanding Admin Console
Icon
The Informatica architecture
Icon
Informatica services
Icon
The Administration Console - configuration
Icon
Repository creation - the centralized database for Informatica
Icon
Creating the integration service - the path for flow of data
Icon
Model Repository Service - a storage place for other developer tools
Icon
Informatica users and authentications
Icon
Repository Manager - the client configuration
Icon
Summary
3
Understanding Designer Screen and its Components
Icon
Understanding Designer Screen and its Components
Icon
Understanding Designer Interface
Icon
Working with Sources
Icon
Working with Targets
Icon
Feel of data inside Repository - preview
Icon
Creating a Database Table
Icon
Creating a mapping and using transformation features
Icon
Summary
4
The Lifeline of Informatica - Transformations
Icon
The Lifeline of Informatica - Transformations
Icon
Creating the transformation
Icon
Expression transformation
Icon
Ports in transformations
Icon
Using the expression editor
Icon
Aggregator transformation
Icon
Sorter transformation
Icon
Filter transformation
Icon
Router transformation
Icon
Rank transformation
Icon
Sequence Generator transformation
Icon
Joiner transformation
Icon
Union transformation
Icon
Source Qualifier transformation
Icon
Classification of transformations
Icon
Lookup transformation
Icon
Update Strategy transformation
Icon
Normalizer transformation
Icon
Stored Procedure transformation
Icon
Transaction Control transformation
Icon
Types of Lookup cache
Icon
Tracing level
Icon
Summary
5
Using the Designer Screen - Advanced Features
Icon
Using the Designer Screen - Advanced Features
Icon
Debug me please - the debugger
Icon
Reuse me please - reusable transformation
Icon
Managing the constraints - the target load plan
Icon
Avoid hardcoding - parameters and variables
Icon
Comparing objects
Icon
Summary
6
Implementing SCD Using Designer Screen Wizards
Icon
Implementing SCD Using Designer Screen Wizards
Icon
Types of SCD
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
7
Using the Workflow Manager Screen
Icon
Using the Workflow Manager Screen
Icon
Using the Workflow Manager
Icon
Creating a workflow
Icon
Adding a task to the workflow
Icon
Working with the Session task and basic properties
Icon
Assigning the integration service to the workflow
Icon
Deleting a workflow
Icon
Trigger - starting a workflow
Icon
Working with Connection objects
Icon
Summary
8
Learning Various Tasks in Workflow Manager screen
chevron up
Icon
Learning Various Tasks in Workflow Manager screen
Icon
Working with tasks
Icon
Configuring a task
Icon
Session task
Icon
Command task
Icon
Email Task
Icon
Assignment Task
Icon
Timer task
Icon
Control task
Icon
Decision task
Icon
Event tasks - Event Wait and Event Raise
Icon
Link task
Icon
Worklets - Groups of tasks
Icon
Summary
9
Advanced Features of Workflow Manager Screen
Icon
Advanced Features of Workflow Manager Screen
Icon
Schedulers
Icon
File list - the indirect way
Icon
Incremental Aggregation
Icon
Parameter file - parameters and variables
Icon
Summary
10
Working with Workflow Monitor - Monitoring the code
Icon
Working with Workflow Monitor - Monitoring the code
Icon
Using the Workflow Monitor
Icon
Connecting the Workflow Manager Screen
Icon
Opening previous workflow runs
Icon
Running or recovering workflow or task
Icon
Stopping or aborting the workflow or task
Icon
Status of the workflow and tasks
Icon
Viewing 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
11
The Deployment Phase - Using Repository Manager
Icon
The Deployment Phase - Using Repository Manager
Icon
Using the Repository Manager
Icon
Take me to the next stage - Deployment or Migration
Icon
Summary
12
Optimization - Performance Tuning
Icon
Optimization - Performance Tuning
Icon
Bottlenecks
Icon
Working on partitioning
Icon
Pushdown optimization
Icon
Summary

Working with tasks

As mentioned in the previous chapter, tasks are the basic building blocks of Workflows. Every task has a different functionality as every transformation has a different functionality. We need to use tasks as per our requirement in the workflow or worklet. Tasks can be created as reusable or non-reusable.

You can create reusable tasks in Task Developer and non-reusable tasks in Workflow Manager.

Before we talk in detail about each task, let's have a brief understanding of the different tasks we have:

Name of task

Details

Session task

This is used to execute a mapping.

Email task

This is used to send success or failure email notifications.

Command task

This is used to execute Unix/Perl scripts or commands. It can also be used to execute DOS commands in Windows.

Timer task

This is used to add some time gap or delay between two tasks.

Assignment task

This is used to assign a value to Workflow variables.

Control task

This is used to control the flow of the workflow by stopping or aborting...

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 10.x
End of Section 8
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