Assembly: Cubes;
The ICubeLoaderFromSource interface contains properties and methods that are used to load data with the ability of transformation by dimensions.
ICubeLoaderFromSource
To create a cube and load data to it:
In the RdsDatabase property specify the MDM repository, in which the MDM table dictionaries underlying the dimensions of the cube will be created. The MDM repository may not be specified, in this case MDM table dictionaries will be created in the database specified in the Database property.
In the Database property specify the database, in which a table with cube values will be created.
In the Parent property specify the folder of the repository where the cube and the table will be saved.
Initialize the data source described by the IDtProvider interface.
Call the Init method to initialize the DimensionBindings and FactBindings collections containing parameters of binding of dimensions and facts. Make any changes in these collections if required.
Call the Load method to create a standard cube and all required objects, and to load data.
Property name | Brief description | |
AddAllFields | The AddAllFields property determines whether data by the fields that are not mapped with cube dimensions or facts is loaded to data table. | |
AdditionalFields | The AdditionalFields property returns the collection, to which unmapped source fields are included that must be loaded to cube output matrix. | |
CreateETLTask | The CreateETLTask property determines whether an ETL task is created that contains a data import chain from selected data source to data consumer. | |
CreateCacheKeeper | The CreateCacheKeeper property determines whether a cached data warehouse is created. | |
Cube | The Cube property determines the cube, to which the data will be loaded. | |
Database | The Database property determines the database, in which a table to store the cube data is created. | |
DimensionBindings | The DimensionBindings property returns parameters of dimension binding to data source fields. | |
EditExistingObject | The EditExistingObject property determines whether the structure of the object, to which data is loaded, is edited. | |
FactBindings | The FactBindings property returns parameters of binding cube facts to data source fields. | |
IsMetabaseProvider | The IsMetabaseProvider property determines whether source data is loaded to repositories. | |
LoadDuplicates | The LoadDuplicates property determines whether duplicate records will be loaded on data loading. | |
Parent | The Parent property determines the repository folder, in which a cube and all required objects are created. | |
RdsDatabase | The RdsDatabase property determines the MDM repository, in which the dictionaries corresponding to cube dimensions are created. | |
Rubricator | The Rubricator property determines the time series database, to which the data will be imported. | |
Type | The Type property determines the type of repository object, to which data is loaded. |
Method name | Brief description | |
Init | The Init method configure parameters of dimensions and facts description according to the data source fields. | |
Load | The Load method loads data. | |
LoadWithResult | The LoadWithResult method loads data and returns loading result. |
See also: