Data Transformation Engine Design Studio Tutorial

Chapter 12 - Mapping Optional Inputs Scenario
Design Studio Tutorial
228
Scenario
A data file of statistics on states in the United States may include population
density, median household income, average summer temperature, average winter
temperature, and average yearly rainfall.
You need to generate a file that contains only the population statistics.
Input Data
The input data is provided in the Sts.txt file. This file contains weather and
human statistics on states in the United States:
Midwest:OH/257,3738/74,31,37:IL/,4285/76,26,33:IN/142,3687/75,29,39
Mountain:MT/5,3130/68,19,11:ID/8,2953/75,29,11:WY/3,3353/70,26,15
Plains:MN/48,3635/73,12,25:IA/,3549/74,20,33:MO/67,3458/78,32,35
The diagram shows how the data objects within a Region are organized. A
Region consists of a RegionID, and a series of States. Each State consists of a
StateID, Human, and Weather statistics.
Region
Human
Weather
RegionID
M
idwest:OH/257,3738/74,31,37:IL/196,4285/76,26,33:IN/142,3687/75,29,39
State State State
StateID
The statistics for population density and household income are within each
Human data object. The statistics for average summer temperature, average
winter temperature, and average yearly rainfall are within each Weather data
object.
Human
Weather
M
idwest:OH/257,3738/74,31,37:
Population Income
Summer
Winter
Rain
You need to extract each StateID and corresponding Population.