Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Learning Informatica PowerCenter 10.x Enterprise data warehousing and intelligent data centers for efficient data management solutions

Product type Paperback

Published in Aug 2017

Publisher

ISBN-13 9781788471220

Length 426 pages

Edition 2nd Edition

Tools

Informatica PowerCenter

Concepts

Data Processing

Author (1):

Rahul Malewar

View More author details

Table of Contents (13) Chapters

Preface

1. Downloading and Extracting Informatica PowerCenter Software

2. Understanding Admin Console FREE CHAPTER

3. Understanding Designer Screen and its Components

4. The Lifeline of Informatica - Transformations

5. Using the Designer Screen - Advanced Features

6. Implementing SCD Using Designer Screen Wizards

7. Using the Workflow Manager Screen

8. Learning Various Tasks in Workflow Manager screen

9. Advanced Features of Workflow Manager Screen

10. Working with Workflow Monitor - Monitoring the code

11. The Deployment Phase - Using Repository Manager

12. Optimization - Performance Tuning

Working with Targets

As we saw in the previous section, PowerCenter can use different types of Sources. Similarly, PowerCenter is capable of working with different types of targets to load data:

Relational Database: PowerCenter supports all the relations databases such as Oracle, Sybase, DB2, Microsoft SQL Server, SAP HANA, and Teradata.
File: This includes flat files (fixed width and delimited files), COBOL Copybook files, XML files, and Excel files.
High-end applications: PowerCenter also supports applications such as Hyperion, PeopleSoft, TIBCO, WebSphere MQ, and so on.
Mainframe: Additional features of Mainframe such as IBM DB2 OS/390, IBM DB2 OS/400, IDMS, IDMS-X, IMS, and VSAM can be purchased
Other: PowerCenter also supports Microsoft Access and external web services.

Let's start!

...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Rahul Malewar

Rahul Malewar has been working on various Data Warehousing tools for 10 years, primarily on Informatica Power Center. He has worked on various versions of Informatica Power Center, from version 8.1 to the latest version, 9.x, and Informatica Cloud. He has worked in various MNC's in India such as UST Global, Cognizant Technologies, and Principal Financial services in Pune, India. He has worked on the implementation of some Data Warehouses involving Informatica for fortune 500 MNC's such as Wellpoint, Principal. He has experience in working on multiple real-time projects in a couple of MNC's; utilizing those skills, he has written the book. He has now been running his own training center named Learn Well Technocraft (www.dw-learnwell.com) since 2010; here, he provides training on more than 25 Data warehousing technologies via 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,200 candidates ranging from freshers to professionals with 20 years' experience. He is also a Director of a software 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 topics and other technical issues; he can be contacted at info@dw-learnwell.com.

See other products by Rahul Malewar