ITPub博客

首页 > Linux操作系统 > Linux操作系统 > timestamp in data extraction

timestamp in data extraction

原创 Linux操作系统 作者:wangxuanping 时间:2011-09-22 16:15:05 0 删除 编辑

As we known, there will be two kinds of data update mode in BW generally, Full and Delta. The full update is for the condition in which you want to load data with your limitations, as the delta update just for loading fresh data not existed. For delta two situations should be taken into account. For Logistics delta queue is perfect, while timestamp for Finance. Mostly an  Init.  will be done before delta, however ,timestamp cause a delay between timestamp and accounting time. For example, a voucher is done while accounting isn't not existed in DB level), so in the data extraction this record will not be gotten. In order to solve this issue, SAP provider user a method in which you can definite a range called lower limiter and upper limiter, when extracting it .

     Here comes a simple sample for you, data extraction per 6 hours. Considering 12:00 as start-point, data created between 06:00 and 12:00 will be loaded. However, if you have created a voucher at 11:55 and after a lunch doing an accounting at 12:30, unfortunately it is lost in data extraction. So lower limit will do a favor for you when setting it to 30 minutes, then data-fresh ranges from 05:30 to 12:00 will suitable for extraction. As same as lower limiter, upper limiter will extract data ranging 06:00 to 11:30.

    For the developer adopting it, ODS will be your first choice in Info Provider  due to overwrite duplicated data.

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22464099/viewspace-708105/,如需转载,请注明出处,否则将追究法律责任。

上一篇: SID Table
请登录后发表评论 登录
全部评论

注册时间:2009-09-02

  • 博文量
    34
  • 访问量
    78173