Community Sites
Create your own community website and start earning today !
It's Free !

Forum Resources Mentors Projects Entrance Exams Question Papers Colleges Courses Universities Schools Make Money

Communities Members Bookmarks Polls Fresher Jobs Funny Photos B.Tech Projects New Member FAQ

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

bharath (1335)
Girish Patil (1271)
sunil (1182)

more...

Awards & Gifts

Online Exams

Fresher Jobs

Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian cities including Bangalore, Chennai, Hyderabad, Pune or Kochi

Resources

Find educational articles, blogs, discussion threads and other resources.

Colleges

Find details about any college in India or search for courses.

Top 10 Best Practices for Building a Large Scale Relational Data Warehouse

Posted Date: 12 May 2008 Total Responses: 1

Posted By: sac Member Level: Diamond Points: 1

1.Consider partitioning large fact tables
2.Build clustered index on the date key of the fact table
3.Choose partition grain carefully
4.Design dimension tables appropriately
5.Write effective queries for partition elimination
6.Use Sliding Window technique to maintain data
7.Efficiently load the initial data
8.Efficiently delete old data
9.Manage statistics manually
10.Consider efficient backup strategies

i will create blog which explains all in details . please suggest me any new additional information required here.
Thanks,
Sac

Responses

Author: Shyni 31 May 2008

Member Level: Gold

Rating:

Points: 2

Thanks for sharing such nice information

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Ask for any IT /techinal books...
	Previous : Source code
	Return to Discussion Forum
	Post New Message
	Category: General

Related Messages

Watch TV Channels

Watch Asianet TV online

Kairali TV in Internet

Surya TV online

Amritha TV Channel