博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
Change log data for DSO
阅读量:5134 次
发布时间:2019-06-13

本文共 1225 字,大约阅读时间需要 4 分钟。

Change Log Data : I think there is lot of confusion in forums on deleting changelog data. Some say we can delete the changelog data no problem, some say we will get incorrect data if there are any updates for deleted old data.

For the record, change log data can be deleted, there are no issues with it even when we get changes for the records we deleted. Here is how change log /delta from ODS to the cube works.
1.    Data is first loaded into new table (This is before ODS activation)

2.    ODS Activation : During activation SAP compares records in new table with records in active table and generates changelog records and puts them under a unique id which corresponds to request id in the active table. Records in new table are deleted at the end of activation.

3.    Now when you do a delta from the ODS to the cube it loads the records from changelog table based on request id, after the delta load is complete the records in change log table are never used for anything again unless you want to reconstruct/reload data requests by requests.

4.    Even if you need to reload you do it by either full or delta init loads or data will be loaded from active table.

转载于:https://www.cnblogs.com/huggins/archive/2012/03/08/2385267.html

你可能感兴趣的文章
WPF中实现多选ComboBox控件
查看>>
ionic2+ 基础
查看>>
MyBaits动态sql语句
查看>>
用户空间与内核空间,进程上下文与中断上下文[总结]
查看>>
JAVA开发环境搭建
查看>>
Visual Studio基于CMake配置opencv1.0.0、opencv2.2
查看>>
django迁移数据库错误
查看>>
Data truncation: Out of range value for column 'Quality' at row 1
查看>>
字符串处理
查看>>
HtmlUnitDriver 网页内容动态抓取
查看>>
ad logon hour
查看>>
罗马数字与阿拉伯数字转换
查看>>
Eclipse 反编译之 JadClipse
查看>>
距离公式汇总以及Python实现
查看>>
Linux内核态、用户态简介与IntelCPU特权级别--Ring0-3
查看>>
第23月第24天 git命令 .git-credentials git rm --cached git stash clear
查看>>
java SE :标准输入/输出
查看>>
[ JAVA编程 ] double类型计算精度丢失问题及解决方法
查看>>
好玩的-记最近玩的几个经典ipad ios游戏
查看>>
PyQt5--EventSender
查看>>