Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
205
Chapter 11 - Partitioning Types to
Simplify Map Rules
This chapter defines how to partition types to simplify map rules. Partitioning is a
method of subdividing data objects into mutually exclusive subtypes. Data that
can be divided into mutually exclusive subtypes can be partitioned.
Partitioning is required when components are randomly or partially ordered.
You may decide to use partitioning in a type tree to build additional logic into the
definition of the data. You may also use partitioning to simplify the rules needed in
your map.
Objectives
This exercise uses a single input file to generate multiple output files using
partitions and attributes.
By completing the exercises for Chapter 11, you will learn how to:
♦ Partition to simplify map rules.
♦ Identify partitions in map rules and component rules.
♦ Use the identifier attribute to distinguish record types.
♦ Generate multiple output files from a single input file.
♦ Use the CURRENTDATE function.
♦ View type properties in the Map Designer.
♦ View component numbers in the group window.
♦ Use the multiply (
*) and divide (/) operators.
♦ Calculate percentages of Customer and Distributor records in an input file.