Hi,

I have mainly two questions (that could lead to others ...) :

1- is there a website that talks about star schema modeling : which keys
(id, date,... ) to choose as dimensions, facts, internal vs external keys
....

2- how to deal with updates : use full or delta files, which data should be
updated and which one historised (is it the correct term ?), tools (ETL,
SQL,...) best practice.

Sorry for my average english and thanks a lot for your help

Hi,

An outstanding free resource for this information is Ralph Kimball's
website. He has a number of excellent articles on the topics you are
requesting more information about. His books on dimensional modeling
and ETL practices are also considered authoritative volumes on these
subjects.

http://www.ralphkimball.com/html/articles.html

Good Luck,

Nenshad

Many thx,
Jug

"Nenshad Bardoliwalla" <nenshad (AT) gmail (DOT) com> wrote