How to handle Large dimensions 35M records

Preserving prior history for late arriving dimensions

Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and

Large Dimension table compared to fact table?

I may be misguided in my attempt to make a dimensional model here, but I will explain the scenario. We provide a value add service in the supply chain business...in this case by depicting a scorecard of the accuracy of vendors' product sizing

Modeling multiple multivalued dimensions and other design questions

Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in

How long should -1 dummy records exist in fact tables?

Dear Kimball Group, we are using the Kimball BUS Architecture method with SQL Server 2005, SSIS, SSAS, ProClarity, PPS, and MOSS. I am at a clients site that is using Full Refresh process for building 3 data marts so far every night. We are trying to

Loading Future Dated Rows to Dimensions

Hi All, Our OLTP system supports effective dated concept. So users can enter Future Dated Rows also. And in our Warehouse we have both Type1 Dimesnions and Type2 Dimensions. When loading the data to Type1 dimesnions, if we load future dated row

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

How to handle a Flame War situation.

Flame wars have been popping up a few times, while rare, if it does happen, this will teach you what and what not to do when in/discovering a Flame War. What to do on Pivetworld: 1. Try not to get involved. 2. Always log out if you sense a Flame

large scale baja

choice of category: sports and hobbies choice of title: large scale baja forum adress: http://largescalebaja.forumotion.com/ main language: english only forum description: forum created for persons interested in large scale

How to manage Conformed dimensions

Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

Little Fighter 2 World Records

It's copied from LF-Empire, but i also would like you to make new records. I would like to add a Topic where everyone can find the actual world records in Survival Stage.(Good to make this sticky) Here everyone can add his recording and tell what kind

Dimension loading sources

Hi all, It's about datawarehouse dimension loading : should i load dimension from a master data management referential or from the truth of my business application. In the first case, dimension will be cleaner than in the second case but it will not

MDX(or something else) for getting history based on last dimension characteristic for SCD.

Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit

Crystal Animations: Large bump-date

Custom stick test Nameless madness The mad adventure: Note, this one is long so it's not as good in quality as the others, also, it's going to be continued. Click here to view it; I had to upload it to imageshack and post a link because Imgserv