数据仓库相关资料索引

davissun · 发表于 2011-3-2 10:47

太好了，内容比较详细。

Wunkang · 发表于 2011-3-15 16:24

记号~~~

cyjzss · 发表于 2011-4-6 17:37

谢谢楼主分享

ailsa-2012 · 发表于 2011-4-7 13:46

Headcount：2
Location：Hangzhou（杭州）
Job Description:

Key responsibilities of this position include database architecture, database administration, database physical and logical design, and SQL programming and tuning.

Job Qualification
1. 5+ years database related experience.
2. Proficient at SQL programming and tuning, and store procedures
3. Experienced on Oracle database administration.
4. Experienced on database design and architecture
5. Familiar with JDBC/ADO.Net.
6. Excellent at communication skills and teamwork
7. Capable of English writing and speaking
8. Excellent at analytical and system thinking
9. Bachelor degree or above

MSN:ailsa-fang2010@hotmail.com

Email:fang_zhao@goldbuilder.cn

叶晓菊 · 发表于 2011-4-14 03:08

我在设计OLAP 的 ER DIAGRAM. 在每一个DIMENSION TABLE,我加了一个PRIMARY KEY. 我想在OLTP对应的
TABLE也加一个PRIMARY KEY.加primary Key 的目的是INFORMATIC load data can easy figure out which
is new data, which we need to update. 但现在我的问题是OLTP的ER design 的人,拒绝去加primary key.
原因是这样回影响load data 的速度. 我想问一下, 大家在ETL 是都是如何去知道delta data??谢谢