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 FREE CHAPTER

2. Understanding Admin Console

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 Sources

Any file or table from where we can extract the data in PowerCenter is referred to as the Source. You can import or create the source definition.

When you import the source definition in Designer, we import only the metadata, that is column names, data type, size, indexes, constraints, dependencies, and so on. Actual data never comes with the Source structure in Designer. The data flows through the mapping in a row-wise manner when we execute the workflow in Workflow Manager.

PowerCenter allows you to work on various types of sources as listed here:

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: Hyperion, PeopleSoft, TIBCO...

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