After you create mappings in the PowerCenter Designer, you can create a session and use the session in a workflow to extract, transform, and load data. You create sessions and workflows in the Workflow Manager.

You can create a session in a workflow to extract data in batch, change, or real-time mode. You determine how you want the PowerCenter Integration Service to extract the data when you configure the session. You can also create a session to load data to a target.