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

推荐订阅源

aimingoo的专栏
aimingoo的专栏
月光博客
月光博客
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
阮一峰的网络日志
阮一峰的网络日志
博客园_首页
Last Week in AI
Last Week in AI
The Cloudflare Blog
IT之家
IT之家
Hugging Face - Blog
Hugging Face - Blog
美团技术团队
S
SegmentFault 最新的问题
量子位
大猫的无限游戏
大猫的无限游戏
Recent Announcements
Recent Announcements
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
Microsoft Security Blog
Microsoft Security Blog
云风的 BLOG
云风的 BLOG
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
I
InfoQ
人人都是产品经理
人人都是产品经理
G
Google Developers Blog
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Engineering at Meta
Engineering at Meta

博客园 - 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