Book Image

Learning Informatica PowerCenter 9.x

By : Rahul Malewar
Book Image

Learning Informatica PowerCenter 9.x

By: Rahul Malewar

Overview of this book

Table of Contents (18 chapters)
Learning Informatica PowerCenter 9.x
Credits
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Working with the session task – basic properties


Before we can execute the workflow and make the data flow from the source to the target in a mapping, we need to configure some basic properties in a session task. These properties enable the session task to pick the data from the source and load it into the target.

Note

Mapping is only the structural representation of the source and target requirement; actual data movement happens with the properties we define in the session task.

To define the properties, you need to perform a series of steps. In Workflow Manager, open the workflow containing the session task. Double-click on the session task, click on Mapping, and then click on Source.

The Mapping tab of the session task lets you define the properties for the source and the target. Let's discuss the options in detail:

  • Readers: As we are using the Oracle table as our source, the property is mentioned as relational reader. This signifies that our source is a table from where we are extracting...