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

Expression transformation

Expression transformation is used for row-wise manipulation. For any type of manipulation you wish to do on an individual record, use expression transformation. Expression transformation accepts row-wise data, manipulates it, and passes to the target. The transformation receives the data from the input port and sends the data out from the output ports.

Use the expression transformation for any row-wise calculation, for instance, if you want to concatenate the names, calculate the total salary and convert in upper case, and so on. To understand functionality of expression transformation, let's consider the following scenario:

Scenario for expression transformation: Using the flat file we created in Chapter 3, Understanding Designer Screen and its Components as the source, concatenate FIRST_NAME and LAST_NAME to get FULL_NAME, and get TOTAL_SALARY...

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 €18.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