Data Sets Tags
The data-sets block lists the data sets that are used in the factory configuration. Within each data-set block you specify rules for that data set.
In the following example, the individual data set blocks are collapsed:
data-sets { data-set "Accounts" { data-set "Charges" { data-set "Payments" { }
NOTE: In Workbench 7.1(13) and later, all Spectre Build input types (*-input) can be included in the data-set block. Operations, such as filter and limit-rows, are supported inside the input tag block. For the complete list of operational attributes, see General Build Tags, Text, cBase, and Dive Input Build Tags, and ODBC Input Build Tags. Data sets always begin with a single table of data.
Data Sets Tags
Tags | Examples | Notes |
---|---|---|
data-sets |
data-sets { data-set "Accounts" { ... } data-set "Charges" { ... } ... } |
Defines the container tag for data-set tags. |
data-set | data-set "Accounts" { ... } |
Code block that names the data set and starts the sub-block. NOTE: Each data set defined in the data-sets block must be used in at least one |
file | data-set "Accounts" file="data-sets/Accounts.factory-data-set" | Supporting tag for data-set when using separate factory-data-set files along with the main cfg.factory. See Multiple Configuration Files. |
cbase-input |
cbase-input "/cbases/accounts.cbase" | Sub-tag for data-set that specifies the location of the cBase that provides input for the data set. |
dive-input | dive-input "/programs/Profit.dive" | Sub-tag for data-set that specifies the location of the Spectre Dive that provides input for the data set. Additional operations are supported. |
odbc-input | odbc-input query-path="/programs/inventory.sql" | Sub-tag for data-set that specifies the location of the ODBC input for the data set. Additional operations are supported. |
plugin |
plugin "Build" { dimension "Color" plugin-rule "Letter" } |
Sub-tag for data-set that specifies the factory plugin (Build in this example) that provides input for the data set. Here the output column Letter is defined as a plugin-rule in the data set. |
plugin-input |
plugin-input "Plugin Name" { ... } |
Sub-tag for data-set that specifies a factory plugin as the source of the data. The data set will start with the rules specified in the plugin-input. With this feature, some operations that needed to be done in ETL before the factory was built can now be incorporated into the factory itself. See Plugin Versus Plugin-input. |
plugin-rule |
plugin-input "Generate" { plugin-rule "Color" plugin-rule "Mood" } plugin "Concat" { dimension "Key" plugin-rule "Revenue Desc" } |
Sub tab for plugin-input and plugin that names the rule that corresponds to the column output by the named plugin (Generate and Concat in these examples). |
text-input | text-input "/data/daily transactions.txt" | Sub-tag for data-set that specifies the location of the text file that provides input for the data set. Additional operations are supported. |
tunnel-input | tunnel-input "/programs/todays-data.tnl" | Sub-tag for data-set that specifies the location of the Tunnel input included in the data set. |
shift-current-date |
shift-current-date | Shifts the current date forward by one day for any calculations on this data set, overriding the |
<rules> |
data-set "Account"{ cbase-input /cbases/accounts.cbase" <calc-rules> <flag rules> <lookup rules> <plugin rules> <source rules> } |
Sub-tags for data-set that describes each rule for the data set. For more information, see Rules Tags. |
See also About Data Sets.