ITableCreator
Assembly: Cubes;
Description
The ITableCreator interface contains properties and methods that are used for automatic creation of repository tables.
Inheritance Hierarchy
ITableCreator
Comments
To create a table:
Initialize object of the TableCreator class.
Select the database, in which the table is created, in the Database property.
Specify the source on the basis of a structure and data, on which the table is formed in the Source property.
Specify the information about the created repository table in the ObjectCreateInfo property.
Call the Execute method.
A table is created in the repository according to the ObjectCreateInfo information, and the structure similar to the structure of the Source data source after specifying all the parameters and calling the Execute method. The corresponding physical table is also created on the database server, which settings are specified in the Database database. All the data from the selected source is loaded to the table.
To limit the data loading, specify the DataRow and RowCount properties.
Properties
| |
Property name |
Brief description |
 |
Connection |
The Connection property determines a binding, in which the queries of tables creation and data load are executed. |
|
Database |
The Database property determines a database, in which a table is created. |
|
DataRow |
The DataRow property determines a row index in the data source, which is the starting point to load the data to the table. |
|
Fields |
The Fields property returns the collection of data source fields, based on which table fields are created. |
|
ObjectCreateInfo |
The ObjectCreateInfo property determines description of the repository object that corresponds to the created table. |
|
RowCount |
The RowCount property determines the number of data rows, which must be loaded to the created table. |
|
SkipEmptyRows |
The SkipEmptyRows property determines the attribute of skipping empty rows. |
|
Source |
The Source property determines the source, based on which the table is created. |
Methods
| |
Method name |
Brief description |
 |
AddConverter |
The AddConverter method transforms values of the specified field. |
|
Execute |
The Execute method creates a table and loads data into it. |
See also:
Cubes Assembly Interfaces