A mapping specification is an asset that describes the movement and transformation of data from a source to a target. Use a mapping specification to define business logic that populates a target table with data that you can leverage to report on the target table.
Story
HypoStores wants to develop business logic that can populate a target table with the current balance for each branch in a financial organization. You are the analyst who is responsible for developing a mapping specification that generates current balance data for active customer accounts for a set of financial products in the target table.
Objectives
In this lesson, you complete the following tasks:
Create a mapping specification with two sources and a target.
Add a simple filter to the mapping specification.
Add a rule to the mapping specification.
Load the results of the mapping specification to a target.
Prerequisites
Before you start this lesson, verify the following prerequisites:
You have completed Lessons 1 and 2 in this tutorial.
Timing
Set aside 10 to 15 minutes to complete this lesson.