45,59 €
Mehr erfahren.
- Herausgeber: Packt Publishing
- Kategorie: Wissenschaft und neue Technologien
- Sprache: Englisch
Harness the power and simplicity of Informatica PowerCenter 10.x to build and manage efficient data management solutions
About This Book
- Master PowerCenter 10.x components to create, execute, monitor, and schedule ETL processes with a practical approach.
- An ideal guide to building the necessary skills and competencies to become an expert Informatica PowerCenter developer.
- A comprehensive guide to fetching/transforming and loading huge volumes of data in a very effective way, with reduced resource consumption
Who This Book Is For
If you wish to deploy Informatica in enterprise environments and build a career in data warehousing, then this book is for you. Whether you are a software developer/analytic professional and are new to Informatica or an experienced user, you will learn all the features of Informatica 10.x. A basic knowledge of programming and data warehouse concepts is essential.
What You Will Learn
- Install or upgrade the components of the Informatica PowerCenter tool
- Work on various aspects of administrative skills and on the various developer Informatica PowerCenter screens such as Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Get practical hands-on experience of various sections of Informatica PowerCenter, such as navigator, toolbar, workspace, control panel, and so on
- Leverage basic and advanced utilities, such as the debugger, target load plan, and incremental aggregation to process data
- Implement data warehousing concepts such as schemas and SCDs using Informatica
- Migrate various components, such as sources and targets, to another region using the Designer and Repository Manager screens
- Enhance code performance using tips such as pushdown optimization and partitioning
In Detail
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.
Style and approach
You'll get hand-on with sources, targets, transformations, performance optimization, scheduling, deploying for processing, and managing your data, and learn everything you need to become a proficient Informatica PowerCenter developer.
Sie lesen das E-Book in den Legimi-Apps auf:
Seitenzahl: 303
Veröffentlichungsjahr: 2017
Ähnliche
Second Edition
BIRMINGHAM - MUMBAI
Learning Informatica PowerCenter 10.x
Second Edition
Copyright © 2017 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: December 2014
Second edition: August 2017
Production reference: 1090817
ISBN 978-1-78847-122-0
www.packtpub.com
Credits
Authors
Rahul Malewar
Copy Editor
Manisha Sinha
Reviewers
Umamaheswaran
Project Coordinator
Manthan Patel
Commissioning Editor
Sunith Shetty
Proofreader
Safis Editing
Acquisition Editor
Vinay Argekar
Indexer
Tejal Daruwale Soni
Content Development Editor
Jagruti Babaria
Graphics
Tania Dutta
Technical Editor
Danish Shaikh
Production Coordinator
Deepika Naik
About the Author
Rahul Malewar is a data warehouse consultant, providing Business Intelligence and Data Analytical solutions to customers. He has worked on various Data Warehousing tools for 10 years, majorly on Informatica Power Center--various versions of Informatica Power Center, from version 8.1 to the latest 10.1.0. He has experience of working on multiple real-time projects in a couple of MNCs, utilizing the skills acquired from which, he has written this book. He has been running his own training center named Learn Well Technocraft (www.dw-learnwell.com) for seven years now, wherein training on more than 25 Data warehousing, Cloud Computing, and Data Analytical technologies is provided over classroom, corporate, and online means. He has also written a blog on data warehousing concepts. As of today, he has provided training to more than 1,700 candidates, ranging from freshers to professionals with 20 years of experience in Informatica.
Rahul has also worked on Informatica cloud and has implemented projects on it. Apart from this, he has also provided training on Informatica cloud to big organizations such as monster.com (US).
He is the Director of a software development firm named Gut Lernen Technocraft Pvt. Ltd., where they work on data warehousing and mobile-related projects.
He provides free assistance on Informatica installation-related and other technical issues, for which he can be contacted at [email protected].
Acknowledgement
With the release of 2nd book, I would like to dedicate the book to my 3 year young kid Swara for giving all the happiness and bringing lot of good charm to our family.
With this I also dedicate the book to my parents who took the pain of my childhood and helped me and understood all decision in my life.
Last but not the least, special thanks to my wife Swati, for understanding and standing along even when I am able to give her enough time.
Also a special Thanks to Packt publications for giving me opportunity to write the 2nd book and also to the reviewers and other members I worked while release of book.
And a big thanks to the readers of the Learning Informatica Power Center 9.x book for purchasing and liking the book. I hope you will like the latest release of book as well.
Wish you all the luck for future. Keep smiling and make others smile and make our mother earth a better place to live.
About the Reviewer
Umamaheswaran (Uma) is the Founder & CEO of Ulagellam Pvt Ltd, a lecturer turned software engineer turned entrepreneur, Uma has 17+ years of experience in the Industry, served clients from Japan, United States & Middle East.
Uma worked as a software engineer in Citi Japan, Kaiser, Wells Fargo and with the mighty Yahoo at their headquarters in Sunnyvale, California.
Uma is a regular bootcamper, speaks less, listens more, loves to spend most of his time with his laptop, exploring new things and fighting with them :-)
Uma has also reviewed books on Drools Cookbook, Learning Informatica PowerCenter 9.x, Java Hibernate Cookbook reviewed latest video course on Getting started with Informatic from Packt publishing. For further details visit http://ulagellam.com
www.PacktPub.com
For support files and downloads related to your book, please visit www.PacktPub.com.
Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at [email protected] for more details.
At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks.
https://www.packtpub.com/mapt
Get the most in-demand software skills with Mapt. Mapt gives you full access to all Packt books and video courses, as well as industry-leading tools to help you plan your personal development and advance your career.
Why subscribe?
Fully searchable across every book published by Packt
Copy and paste, print, and bookmark content
On demand and accessible via a web browser
Customer Feedback
Thanks for purchasing this Packt book. At Packt, quality is at the heart of our editorial process. To help us improve, please leave us an honest review on this book's Amazon page at https://www.amazon.com/dp/1788471229.
If you'd like to join our team of regular reviewers, you can e-mail us at [email protected]. We award our regular reviewers with free eBooks and videos in exchange for their valuable feedback. Help us be relentless in improving our products!
Table of Contents
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
Preface
In lines with the release of book Learning Informatica PowerCenter 10.1.0, we have tried to present a technology in its most simple form to the readers. We have tried to explain every aspect for new learners of Informatica. Also, we have covered everything for the users of the older version to upgrade to the latest version. This book covers everything, from basics, such as downloading, extraction, and installation, to working on the client tools and then high-level aspects such as scheduling, migration, performance optimization, and so on in simple words. The use of this book will eliminate the need to browse multiple blogs available on the internet that talk about Informatica tool. What you get in this book is everything from start to end; using this book, you can develop and deploy end-to-end projects on Informatica. In this book, you will get the step-by-step procedure for every aspect of Informatica Power Center Tool. Informatica Corporation (Informatica), a multimillion dollar company incorporated in February 1993, is an independent provider of enterprise data integration and data quality software and services. The company enables a variety of complex enterprise data integration products, which include Power Center, Power Exchange, enterprise data integration, data quality, master data management, business-to-business (B2B) data exchange, application information life cycle management, complex event processing, ultra messaging, and cloud data integration. You are going to learn the latest version of Power Center tool of Informatica in this book. Power Center is the most widely used tool of Informatica across the globe for various data integration processes. Informatica Power Center tool helps integration of data from almost any business system in almost any format. This flexibility of Power Center to handle almost any data makes it the most widely used tool in the data integration world. While writing this book, we kept in mind the importance of live practical exposure of the graphical interface of the tool to the audience, and hence, you will notice a lot of screenshots illustrating the steps to help you understand and follow the process. We have added images depicting every step that you can follow and practice on your own in your machine. You will also get all the screenshots of the installation procedure, which is totally changed from its previous version. We have also provided a lot of real-life examples to help you understand the development aspects in detail. Each concept in the book is self-explanatory, with the precise screenshot of each step. The arrangement of chapters is such that by the end of the book, you will have complete knowledge--from installation to development skills. Let's take small gist of the contents of the book.
What this book covers
Chapter 1, Downloading and Extracting Informatica PowerCenter Software, describes the detailed steps for the installation process starting from the steps of downloading the software, extracting the software, installing the software and configuring the latest version of software.
Chapter 2, Understanding Admin Console, this chapter we will learn the Administrator console of Power Center tool and learn about different services. This chapter talks about creating and configuring various services and also talks about the creation of user for working on Informatica client tool.
Chapter 3, Understanding Designer Screen and its Components, talks about the basics of the Informatica Power Center Designer client tool. You will learn you use most widely used components available on the screen. The chapter also talks about working of the Source files and Source tables and similarly talks about working on targets. We have covered the steps which will help you understand how you can import/create flat files and Relational Databases tables. Also the most important aspect of Informatica Power Center tool, Mappings has been covered in the chapter. We have described in details the steps required to create a mapping. By the end of this chapter you will have clear idea about the look and feel of the Power Center Designer Screen.
Chapter 4, The Lifeline of Informatica - The Transformations is meant for the most important aspect of Informatica Power Center tool, the transformations. We will talk about various types of transformations in this chapter. Every transformation performs a specific functionality and these are the most important aspect of ETL tools. We will implement the mapping using each transformation so that you get to understand each and every transformation in details. Also we will end this chapter with the classifications of the transformation, different types of cache memories available in Informatica and different tracing levels.
Chapter 5, Using the Designer Screen - Advanced Features, talks about the advanced topics of the Designer screen. This chapter is an extension of the Chapter 3. When you work on mappings you usually will need to Debug the process to find the error in your code. Debugger helps you achieve that in very easy manner. We have added a section which will completely help you understand the process to setup the Debugger and steps to use Debugger. The next topic in this chapter talks about the reusable transformation which allows you to reuse the transformations across multiple mapping. On similar lines is Mapplet which is group of reusable transformations. Then we will talk about the Target Load plan, a functionality which allows you to load data in multiple targets in a same mapping maintaining their constraints. It's a very high level concept which you may not need regularly. Also we have touch based on the Compare Objects functionality of the Designer Screen, this allows you to compare objects across the repository.
Chapter 6, Implementing SCD - Using Designer Screen Wizards, covers a single but very important aspect of Data Warehousing, i.e. SCD. We have made a separate chapter for this because this is most important aspect and frequently used concept in Data Warehousing. In this chapter we have outlined the steps required to create a SCD mapping using the wizards in Power Center. We will see the implementation of SCD1, SCD2 and SCD3 using wizards. You should be clear with the Data Warehousing concepts to understand this implementation.
Chapter 7, Using the Workflow Manager Screen, describes the basics of the Workflow Manager screen. This is the second and last phase of our development work. We will get to learn the different option present on the Workflow Manager screen. We will learn to create session task and workflows. We will also see various connections like Relations, FTP etc. which can be created in Workflow Manager screen. We will also learn to execute the workflow. Last topic of the chapter describes about the connections which can be created for database purpose.
Chapter 8, Learning various tasks in Workflow Manager Screen, will teach you the advanced concepts of the Workflow Manager screen. This chapter describes various tasks present in the workflow manager screen. Tasks are the basic building blocks of the workflow as we have transformations in Designer screen. We will also see to make the reusable tasks and Mapplets.
Chapter 9, Advanced features of Workflow Manager Screen, We will see some very important concepts called as Scheduling, Parameter Files, File List and Incremental Aggregation.
Chapter 10, Working with Workflow Monitor Screen, Monitoring the code describes the Workflow Manager screen of Power Center. This screen allows the monitoring of the process we execute in the Workflow Manager. We will see different log files, status and statistics in the Monitor screen.
Chapter 11, The Deployment Phase - Using the Repository Manager is going to teach you about the fourth client screen Repository Manager. Repository Manager is basically used for Migration (Deployment) purpose. We will see various options to migrate the code from one environment to other. Also we will see how to create the folder in client screen.
Chapter 12, Optimization - The Performance Tuning, has the contents for the optimizations of various components of Informatica Power Center tool like Source, targets, Mappings, Sessions, Systems. Performance tuning at high level involves 2 stages, finding the issues called as Bottleneck and resolving them.
What you need for this book
Before you make your mind to learn Informatica, it is always recommended that you have basic understanding of SQL and Unix. Though these are not mandatory and without knowledge of those you can easily 90% of Informatica Power Center tool, to have confidence to work in real time project SQL and Unix is must to have in your kitty. The people who know SQL will easily understand that ETL tools are nothing but the graphical representation of SQL. Unix is utilized in Informatica Power Center with the scripting aspect which makes your life easy at some scenarios.
Who this book is for
Anybody who can read English can use this book...hahahah!!! Jokes apart anyone who wishes to make career in Data Warehousing or Informatica must go for this book. If you are College graduate, IT professional working in other technologies, university professors - This is for you.
Conventions
In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.
Code words in text, database table names, folder names, filenames, file extensions, path names, dummy URLs, user input, and Twitter handles are shown as follows: "We are using EMP_SRC_FILE as reference to import the fixed width file".
New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "Clicking the Next button moves you to the next screen."
Warnings or important notes appear in a box like this.
Tips and tricks appear like this.
Reader feedback
Feedback from our readers is always welcome. Let us know what you think about this book--what you liked or disliked. Reader feedback is important for us as it helps us develop titles that you will really get the most out of.
To send us general feedback, simply e-mail [email protected], and mention the book's title in the subject of your message.
If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide at www.packtpub.com/authors.
Errata
Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books--maybe a mistake in the text or the code--we would be grateful if you could report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the Errata Submission Form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded to our website or added to any list of existing errata under the Errata section of that title.
To view the previously submitted errata, go to https://www.packtpub.com/books/content/support and enter the name of the book in the search field. The required information will appear under the Errata section.
Piracy
Piracy of copyrighted material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works in any form on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.
Please contact us at [email protected] with a link to the suspected pirated material.
We appreciate your help in protecting our authors and our ability to bring you valuable content.
Questions
If you have a problem with any aspect of this book, you can contact us at [email protected], and we will do our best to address the problem.
Downloading and Extracting Informatica PowerCenter Software
In this chapter, you will learn about the various aspects of Informatica's installation, including server and client configuration. You will also learn about the various steps for downloading the correct and latest version of Informatica PowerCenter 10.1.0. This chapter will also teach you how to properly extract the downloaded .zip files.
Let's kick-start learning about the latest offering of Informatica.
Downloading the latest version of Informatica PowerCenter - 10.1.0
To initiate the installation, we will first need to acquire the correct version of the software. The best place to download the Informatica software from for training purposes is the eDelivery website of Oracle. Please perform the following steps to download the latest version (10.1.0) of Informatica PowerCenter:
Visit
https://edelivery.oracle.com
:
Click on
Sign In
to get access to a wide range of software, including Informatica PowerCenter. Log in with valid credentials. If you do not have an account, register for free and create an account with Oracle:
Once you have logged in with valid credentials, accept the Oracle terms and conditions, and click on
Continue
. This will take you to the next screen, shown in the following screenshot:
To download the Informatica PowerCenter software, start typing
informatica powerCenter
in the search box as shown in the previous screenshot. The matching results will start appearing.
Select the option called
Oracle Business Intelligence Data Warehouse Administration Console and Informatica PowerCenter 11.1.1.7.0
.
After you have selected the previous option, select platform based on your operating system. We are selecting Microsoft Windows x64 (64-bit). After you have selected the appropriate platform from the drop-down menu, click on
Select
:
The next screen will allow you to confirm your selection as shown in the following
screenshot
. Make sure the option selected is correct, and click on
Continue
:
The next screen will present you with details about the option you selected for download as shown in the following
screenshot
. Click on
Continue
to go to the next screen:
You will see the terms and conditions and license agreement details. Please read the details carefully as shown in following
screenshot,
and tick the
I have reviewed and accept the terms and commercial License, Special Program License, and/or Trial License
option, and click on
Continue
.
On the next screen, you will see list of compressed
.zip
files, which you need to download for Informatica PowerCenter:
There are multiple files available on the window. The available files also include the compressed files for Informatica PowerCenter version 9.6.1.
Select the files as shown in the previous screenshot download the latest version of Informatica PowerCenter: 10.1.0. A total of eight files needs to be downloaded to get the complete software.
Once you have selected the eight files properly, as shown in the previous screenshot, click on the Download button. Once you have clicked on Download, the website will ask you to download and install the download manager.
Since the size of the files is more, depending on your internet connection speed the files may take some time to download. To avoid issues such as an error in downloading the file because of internet connectivity issues, it is recommended to download the files using the download manager.
After the download manager has been downloaded and installed, it will ask you to select the folder where you want your Informatica PowerCenter 10.1.0 files to be saved. Select the folder of your choice.
With this, our download process is complete, and we have acquired a valid license and software for the latest version of Informatica PowerCenter 10.1.0.
Extracting the downloaded files - preparing the installable
Once the download process is over, you will have eight .zip files available for Informatica PowerCenter 10.1.0 as shown in the following screenshot:
To avoid any confusion with the files later in the installation process, create a separate folder for the Informatica downloaded files. We are using D:\ as the folder for reference. Also, make sure you have sufficient space available (approximately 35 GB).
We will now start extracting the files. Extracting the files in the correct way is important for proper installation. If the files are not extracted correctly, the installation will fail at a later stage. It is recommended that you use the WinRAR software for extraction.
Right-click on the first file V860964-01_1of8, and extract the file in the same folder D:\. Similarly, right-click on other files from V860964-01_2of8 to V860964-01_8 individually, and extract the files in the D:\ folder. The extracted files will look as shown in the following screenshot:
After you finish extracting all the eight downloaded .zip files, right-click on dac_win_11g_infa_win_64bit_101, and extract the file in the same folder D:\. You will get multiple files extracted in the folder.
The next step is to extract the 1010_Server_Installer_wimem-64t and 1010_Client_Installer_wimem-64t files. Right-click on 1010_Server_Installer_wimem-64t, and extract to the D:\1010_Server_Installer_wimem-64t folder. Similarly, right-click on the 1010_Client_Installer_wimem-64t file, and extract to the D:\1010_Client_Installer_wimem-64t folder. This gives you the final folder structure required for installation, as shown in the following screenshot:
This completes the download and extraction process, and we can proceed with the installation process.
The Oracle_America_Inc-OEM-V101-Prod_0115939_136933.key license key required for the installation is present in the extracted folder.
Informatica installation - the prerequisites
Please be careful while you are doing the installation as any issues with the minimum system requirements might hamper the Informatica PowerCenter installation process and you might have to re-initiate the complete installation.
The following points show some prechecks that you need to do before initiating the installation:
Operating system
: Informatica PowerCenter can be installed on Windows-based operating systems or UNIX-based operating systems. Informatica releases different versions of software for different UNIX-based operating systems. For all Windows operating systems, we have a common installable. In this book, we will refer to the Windows operating system.
Database
: Informatica PowerCenter requires a database for configuration. Make sure you have installed a database (Oracle, Microsoft SQL Server, or DB2). In this book, we will refer to Oracle the a database. The installation process requires two different database users. Please make sure you create two database users with all admin privileges. In this book, we are using
SYSTEM
as one user and
HR
as the other user.
System requirements
: We need to check the system capabilities before we proceed with the installation. Informatica recommends 6 GB of RAM for the installation, but practically even 2 GB of RAM works well. The difference shows up in the processing, but it won't hamper the installation process.
Also, approximately 35 GB of hard disk space will be required for the downloaded, extracted, and installed files and folders.
Before downloading the Informatica software, please check whether your machine is a 32-bit or 64-bit one. Informatica 10.1.0 version can be installed only on a 64-bit machine as against previous versions of Informatica, which can be installed on 32-bit and 64-bit machines.
Once you have checked the minimum system requirements, we are all set to take the next step towards installation.
Beginning the installation - installing the server
The Informatica installation requires the installation of the server and the client separately. It is always recommended that you install the server first and then the client.
The installable file for the server can be located by navigating to the folder where you extracted the files. We are using the D:\1010_Server_Installer_winem-64t\Server folder . Navigate to D:\1010_Server_Installer_winem-64t\Server | Server | install as shown in the following screenshot:
Perform the following steps to complete the installation process:
Double-click on
install
to start the installation. In some cases, the file can be present as
install.exe
. This will initiate the installation process for Informatica PowerCenter.
Choose the installation type. If you are installing the Informatica software for the first time, select
Install Informatica 10.1.0
. To upgrade to the latest version from previous versions, select
Upgrade to Informatica 10.1.0
. Also accept the terms and conditions. After you have selected the appropriate option, click on
Next
, as indicated in the following screenshot:
On the next screen, verify the prerequisites for installation as shown in following screenshot. Please make sure your machine satisfies all the prerequisites for installation. Click on
Next
:
The next step, as shown in the following screenshot, is to enter the license key. The license key can be located in the
D:\ Oracle_America_Inc-OEM-V101-Prod_0115939_136933.key
extraction folder. If you are not able to navigate to the path, directly paste the path. Select the installation directory. Click on
Next
:
The next screen will show a pre-installation summary as shown in the following screenshot:
Please check the details, and click on
Install
.
The installation process will begin as shown in the following screenshot. It will take a few minutes before your installation finishes. The installation time depends on your system configuration:
When the installation finishes, we will proceed to the next process: configuring the domain and node.
