Is it possible to build cube(source class:DataConnector) during source table updating?
Hello,
I have a question regarding Data Connector cube.
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=D2IMP_ch_connector
Is it possible to build cube which using data connector for a listing during source table updating?
I defined the simple select query for the SourceQuery in the cube class(Extends %DeepSee.DataConnector)
e.g.
<sql>
SELECT nid, d1, d2 FROM Test GROUP BY nid
</sql>
It was no problem that data inconsistency would occur between fact table and source table data.
It'll update(build cube) once a day.
However, it's a serious problem that source table(e.g.Test) update failed or error.
It looks no problem for building DataConnector cube during source table updating,
because the DataConnector class just run select query for a source table.
Is it possible to build cube(source class:DataConnector) during source table updating?
If it's not possible, what kind of problem will occur?
Additional info:
The table is located same database with the DataConnector class.
It's not a big issue whether the data is updated or not.
Since the cube builds once every late at night, so it does not matter whether the data is one day ago or not.
The important thing is that building a cube at the same time as updating the table does not corrupt the table data(or fail to run the query).