惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

B
Blog
B
Blog RSS Feed
小众软件
小众软件
博客园_首页
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
大猫的无限游戏
大猫的无限游戏
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
博客园 - 聂微东
WordPress大学
WordPress大学
月光博客
月光博客
S
SegmentFault 最新的问题
Engineering at Meta
Engineering at Meta
量子位
V
Visual Studio Blog
罗磊的独立博客
Last Week in AI
Last Week in AI
The Cloudflare Blog
H
Help Net Security
J
Java Code Geeks
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Microsoft Azure Blog
Microsoft Azure Blog
The GitHub Blog
The GitHub Blog
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
美团技术团队

博客园 - Eric小怪物

InfoCube Aggregate聚集介绍 转载:SDN论坛看到的BW问题及其相关解答 BW培训第四课 BW培训第三课 摘抄:对待客户坚持真诚认真--李彦修 SAP BW查看数据源提取方法 BW培训第二课 BW培训第一课 【转载】BWA即将到来的“将来” 学习笔记1-创建InfoObjects对象 BI7.0 IDES虚拟机安装 SAP BW标准模型简介(BW星形模型 BW Star Schema ) SAP BW顾问如何保持市场竞争力 BW InfoObject 学习 BW之基础概念-信息对象(InfoObjects) BW之R3数据源PSA BW中ODS为何物? Oracle 语法之 OVER (PARTITION BY ..) 及开窗函数 如何进入SAP咨询行业
What is difference between PSA and ODS?
Eric小怪物 · 2011-06-29 · via 博客园 - Eric小怪物

PSA: This is just an intermediate data container. This is NOT a data target. Main purpose/use is for data quality maintenance. This has the original data (unchanged) data from source system.

ODS: This is a data target. Reporting can be done through ODS. ODS data is overwriteable. For datasources for which delta is not enabled, ODS can be used to upload delta records to Infocube.  

You can do reporting in ODS. In PSA you can't do reporting directly

ODS contains detail -level data , PSA The requested data is saved, unchanged from the source system. Request data is stored in the transfer structure format in transparent, relational database tables in the Business Information Warehouse. The data format remains unchanged, meaning that no summarization or transformations take place

In ODS you have 3 tables Active, New data table, change log, In PSA you don't have.  *-- Naveeen Kumar