参考资料:
单表CDC增量配置
@Analytics:{
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
automatic : true
}
}
}
多表CDC增量配置
@Analytics:{
dataCategory: #DIMENSION
dataExtraction: {
enabled: true,
delta.changeDataCapture: {
mapping : [ {
table : 'name of table',
role : #MAIN|#LEFT_OUTER_TO_ONE,
viewElement : ['list of CDS view elements'],
tableElement: ['list of table fields']
}, ...
]
}
}
}
1. @analytics.dataExtraction.delta.changeDataCapture.mapping.table
This annotation serves to identify the name of the underlying table(s) to be logged.
此批注用于标识要记录的基础表的名称。
2. @analytics.dataExtraction.delta.changeDataCapture.mapping.role
This annotation is used for identifying the role of a participating table
此注释用于标识参与表的角色
The main table receives the value #MAIN. The key(s) of the CDS view correspond(s) exactly to the key(s) of the underlying main table to be logged. The outer table(s) receive(s) the value #LEFT_OUTER_TO_ONE_JOIN.
主表接收值 #MAIN。CDS 视图的键与要记录的基础主表的键完全对应。外部表接收值 #LEFT_OUTER_TO_ONE_JOIN。
3. @analytics.dataExtraction.delta.changeDataCapture.mapping.viewElement
In case of the main table, (identified by role: #MAIN), this list enumerates all exposed CDS view element names corresponding to the key fields of the main table
对于主表(由角色:#MAIN 标识),此列表枚举与主表的关键字段相对应的所有公开的 CDS 视图元素名称
In case of an outer table, (identified by role: #LEFT_OUTER_TO_ONE_JOIN), this list enumerates all exposed CDS view element names that correspond to key fields in this underlying outer table; in other words that correspond to the foreign key fields used in the on-conditions of the joins.
对于外部表(由角色:#LEFT_OUTER_TO_ONE_JOIN 标识),此列表枚举与此基础外部表中的关键字段相对应的所有公开的 CDS 视图元素名称;换言之,对应于连接条件中使用的外键字段。
4. @analytics.dataExtraction.delta.changeDataCapture.mapping.tableElement
This list enumerates the respective key fields of the underlying tables to be logged.
此列表枚举要记录的基础表的相应关键字段。