General discussion

Locked

Datawarehousing

By mpavankrishna ·
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?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Datawarehousing

by TimTheToolMan 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.

Collapse -

Datawarehousing

by mpavankrishna In reply to Datawarehousing

Poster rated this answer

Collapse -

Datawarehousing

by md_hashim 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/

Collapse -

Datawarehousing

by mpavankrishna In reply to Datawarehousing

Poster rated this answer

Collapse -

Datawarehousing

by mpavankrishna In reply to Datawarehousing

This question was closed by the author

Back to Tips and Tricks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums