Lesson three creating a Pass-Through Mapping,Session and Workflow

In this lesson, create very simple mapping and execute by session and workflow.
Mapping is based on last lesson source and target definitions. Between source and target definition is source qualifier.

Source Qualifier
- When you add a relational or a flat file source definition to a mapping, you need to connect it to a Source Qualifier transformation. The Source Qualifier transformation represents the rows that the PowerCenter Server reads when it runs a sesson.
- Source Qualifier transformation can perform the following tasks:

• Join data originating from the same source database
• Filter rows when the PowerCenter Server reads source data
• Specify sorted ports
  
• Select only distinct values from the source
• Create a custom query to issue a special SELECT statement for the PowerCenter Server to read source data.

Session and Workflow for this lesson are very simple. Looks like most logic are in Mapping. Session just like diagram to link all Mapping. Workflow is just runtime instance of session.