RTOC stands for Rows to Columns transformation. The RTOC transformation reorganizes the data structure of a table from a row based format to a column based format. RTOC is in essence the reverse of the CTOR transformation, Columns to rows, outlined here. RTOC is a common transformation we see, but, very sophisticated to program.
The Data Map component of BPMC automates this transformation through the use of a single, simple configuration while still preserving the performance of the feed. It also automates the optimization and compression of the data, which historically was a challenge within the data map. The RTOC transformation is easier to configure than its sister CTOR transformation. The following depiction attempts to illustrate the transformation visually and how it relates to the data map. The following RTOC example takes two columns: ACCOUNT and AMOUNT and reorganizes the amount of the accounts: PRICE, UNITS, and SALES onto their own measure column. This is achieved by setting up a single line in the data map.
This functionality is available in DBObjects_v1.3.7 or above. In prior versions of DBObjects, while the ROW option was available, it did not work properly. Click here to check your DBObjects version.
See here for more RTOC concepts.
No comments:
Post a Comment