Search This Blog

Tuesday, October 6, 2009

Data Map – CTOR Transformation Concept Illustration

CTOR stands for Columns to Rows. The CTOR transformation reorganizes the data structure of a table
from column based format to a row based format. CTOR is in essence the reverse of the RTOC transformation, Rows to Columns, as described here. This is a common transformation we see, but, very sophisticated to program. The Data Map component of BPMC automates this transformation through the use of some simple configurations while still preserving the performance of the feed.

The CTOR concept on the surface can sometimes be an abstract and complicated concept to digest. The following depiction attempts to illustrate the transformation visually and how it relates to the data map. The following CTOR example consolidates three
columns: PRICE, UNITS, and SALES into one unified "signeddata" column. The values of
the PRICE, UNITS and SALES columns are loaded into a new field called Account.

1 comment: