Tips and Tricks·369 discussions

Datawarehousing

Locked

1. What do you understand by star schema diagram? How do you design one?

2. What is the meaning of slowly changing dimension?

3. What is data cleaning and what are the steps involved in it?

4. What are ETL tools with respect to data warehousing?

Topic

Datawarehousing

In reply to Datawarehousing

Hi,

For question 1 have a look at the following site…

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90237/schemas.htm

(remove spaces from the above and following URLs)

For the second answer have a look at this article…

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=7835

For data cleaning, this is a good paper…

http://www.cs.berkeley.edu/~rshankar/pwheel1.pdf

And finally here is a thread discussing ETL tools. There will be some useful inforhere…

http://www.tek-tips.com/gviewthread.cfm/lev2/77/lev3/25/pid/353/qid/4799

Hope that helps,
Cheers,
Tim.

Datawarehousing

In reply to Datawarehousing

Poster rated this answer

Datawarehousing

In reply to Datawarehousing

1. For star schema details check out http://c2.com/ppr/stars.html
2. For slowly changing dimensions – http://www.dmreview.com/master.cfm?NavID=198&EdID=2263
3. For data cleaning http://www.it.iitb.ernet.in/~rvijay/seminar/new/dwhcleanmeth.html
4.ETL Tools http://www.bitbybit.co.uk/solutions/etl/

Datawarehousing

In reply to Datawarehousing

Poster rated this answer

Datawarehousing

In reply to Datawarehousing

This question was closed by the author

[Author]

Replies