BW: Delete Master Data时的注意事项
来源:互联网 发布:linux ss客户端 编辑:程序博客网 时间:2024/05/26 22:55
Company Code,一个简单的infoobject,我们发现里面有垃圾数据,想要做这个操作,点下去,后果是什么呢?
首先会询问你是否和SID一起删除。
When deleting master data, you can select whether entries in the
SID-table for the characteristic should be kept or deleted.
Effects If you delete the entry in the SID table for a specific
characteristic value, the SID value assigned to the characteristic value
is lost. If you load attributes for this characteristic value later, a
new SID value has to be generated for the characteristic value. This has
a general negative effect on the runtime required for loading. In rare
cases, deleting entries from the SID table can also lead to severe data
inconsistencies if the list of used SID values determined by the
where-used list is incomplete.
Use Note that deletion of entries from the SID table is only useful or
necessary in specific cases. For example, if you want to ensure that
individual values of the characteristic that are no longer deleted
before loading master data attributes or texts, deleting master data and
keeping the entries in the SID table is sufficient.
Deleting from the SID Table is useful, for example, when the composition
of the characteristic key has changed considerably and a larger set of
values is to be swapped for another record with new key values.
但是呢,如果你要删的话,首先系统会自己定义一个后台作业,类似于下图:
命名规则是:BTCH_*
问题就出在这里:
第一:这个作业会先检索所有用到0COMP_CODE的模型,确认该主数据是否还在使用。这个过程相当漫长。
第二:在这个作业运行期间,所有用到0COMP_CODE的模型数据加载都是不允许的。
- BW: Delete Master Data时的注意事项
- BW: Delete Master Data时的注意事项
- BW:Read Master Data:如何规避Slowly Changing Dimension
- BW: 在Infoset中使用Read Master Data
- Automate Master Data Loads from BW to BPC
- mysqldump的--master-data参数
- mysqldump的--master-data参数
- BW Extract Data 综合分析
- Master Data
- Master Data
- BW: How To Delete Workbook
- BW: How To Delete Workbook
- SAP BW : Cannot delete DTP
- 启用 Master Data Services 的 Web Service
- single-transaction 和master-data的用法
- LOAD DATA FROM MASTER的说明
- mysqldump的single-transaction和master-data
- new和delete的一个注意事项
- 数字遗传
- 邮件传输和路由简明教程
- vs2005安装部署不给力,快捷方式右键不能进入目录解决方法
- ORACLE数据库定时执行一些脚本。
- 打log的时候如果少写一个%d,cgi会core掉
- BW: Delete Master Data时的注意事项
- jquery 中jsonp原理最简说明
- listener refused the connection with following err
- tabcontrol不给力,标题不能改解决方法。直接上源码,不注释。
- CSS3资源搜集
- 关于http://www.c41840.com/xx.html恶意病毒(木马)的进一步研究
- 查看 SQL Server 作业(job)运行结果状态脚本(SQL Server 2000 & 2005)
- Iterator设计模式
- 代码覆盖率浅谈