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

Feel of data inside Repository - preview

Now that we have learned how to use Sources and Targets in PowerCenter. We will now start using these sources and targets in mappings. As mentioned earlier in the PowerCenter Designer, we only deal with the metadata of sources and targets, we do have an option to preview the data of the source and target that we imported by providing the path/connection for files or tables. This gives us an option to understand the data clearly before we move ahead with the next step.

Previewing the source data - flat files

Follow these steps to preview the data in source:

Drag and drop the ource from Navigator to Source Analyzer. We are using EMP_FILE as our reference to preview data.

Right-click...

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