| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
|
| Hi All, I have a design question . I got the requirement of 2 TB starting for enterprise dataware house in my project. I want to implement next generation warehousing technique. So want to have a near line storage layer in the design. If we seperate data such that current year and last year will be in SAS(Serial Attached SCSI) drive and next past 3 years will be in Near line. E.g. 2007 and 2008 will be in one cube which is located in SAS and 2006,2005 and 2004 will be in another cube stored in near line storage. Can we develop such cubes seperately and how can we combine these for adhoc query option? Another design is have only one cube and use partitions based on years. 2008 & 2007 partition can be stored in SAS drive and remaining on some other drive. Please help me in this. Thanks, RK |
![]() |
| Thread Tools | |
| Display Modes | |