Book Image

Learning Informatica PowerCenter 10.x - Second Edition

By : Rahul Malewar
Book Image

Learning Informatica PowerCenter 10.x - Second Edition

By: Rahul Malewar

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 (20 chapters)
Title Page
Credits
About the Author
Acknowledgement
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

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:

  1. 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:
  1. 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:
  1. 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.
  2. Select the option called Oracle Business Intelligence Data Warehouse Administration Console and Informatica PowerCenter 11.1.1.7.0.
  3. 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:

Note

Please note that Informatica PowerCenter 10.1 is only available for the 64-bit operating system. You will not be able to use 32-bit machines to install version 10.1.

  1. 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:
  1. 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:
  1. 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.
  2. 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.

Note

Please note that you can select individual files or all eight files together for download. Oracle frequently changes the names of the files. Please make sure you read the description of the files properly before you download.

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.