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

推荐订阅源

爱范儿
爱范儿
量子位
人人都是产品经理
人人都是产品经理
小众软件
小众软件
酷 壳 – CoolShell
酷 壳 – CoolShell
博客园 - Franky
Recent Announcements
Recent Announcements
A
About on SuperTechFans
Microsoft Security Blog
Microsoft Security Blog
N
Netflix TechBlog - Medium
H
Help Net Security
博客园 - 三生石上(FineUI控件)
博客园 - 司徒正美
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
MyScale Blog
MyScale Blog
The Cloudflare Blog
S
SegmentFault 最新的问题
H
Hackread – Cybersecurity News, Data Breaches, AI and More
J
Java Code Geeks
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
P
Proofpoint News Feed
宝玉的分享
宝玉的分享
Vercel News
Vercel News

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