on 04-14-2009 2:21 PM
各位大侠,我请教几个问题。
第一,从Database往BW里面抽数据,是否可以做delta,如何做,是在数据库里面做配置,还是在Infopackage里面写例程。
第二,Database如何从BW里面抽数,open hub service这个功能具体怎么使用。
帮忙解释下,或者提供下,可以看的参考资料。
谢谢.......
1、你可以先用full loading把数据load到ODS用ODS的delta;或者在DB层做一个triger,通过triger产生类于delta的记录;
2、Openhub出来的数据先在BW的数据中,再用VB写一个程序通过RFC读BW中的数据,把通过ADO联你外部DB把数据写到外部的DB中。
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. 从DB做delta抽取,需要数据库表支持的情况下,建议你写abap实现增量.
2. 你可以尝试做下使用open hub把ODS数据导入DB Table的练习.
thanks,
xwu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
关于第二点,这个问题实在太大了 不知从何说起,或许你可以先浏览一下sap的online help..
http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm
-> Data Warehousing
-> Data Retrieval
-> Open Hub Service
这个是netweaver 2004 (也就是BW 3.5)的help..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.