Best Practice Database Schema/user layout

makeing a stand for star schema design

Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information

Star Schema vs All in one table

Hi, I have a scenario where we have dimensional information and the facts in one table rather than a traditional break up into facts and dimensions. What could be the problem i could run into with having all information in one table. Thanks.

Data Warehouse Questions

This year, were planning on creating a data warehouse and implementing an OLAP solution. From what Ive read on this site and others, I will be better off if the data warehouse is designed with a dimensional model. I have a few questions about the

Best Practice For Indexes

Many books have very different opinions on what indexes you should create for a typical star schema having the following generic structure: Fact table fact_surrogate_key dim1_sk dim2_sk dim2_bk (business key -- assuming hybrid type 2 scd, joins bot

Flat Table vs star schema

We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes ) Why not choose a flat table with all data put together instead of a star schema? (well , this question may seem strange, but please help me out here) Few

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

Common elements in web design layout

Creating a website design is not a simple process. You have to know many details related to web designing to give your websites the most perfect look. Web design layouts vary with respect to the requirements and preferences. Here are a few common

selenium with database testing

Hi, Can any one tell me how to test database with selenium as i am testing java application, pls give me some links or some examples as i am new to this testing,waiting for your quick reply.

CARA MENGUBAH LAYOUT FACEBOOK

Aritkel ini saya buat untuk Anda yang suka dengan kostumisasi tampilan dan sekaligus memenuhi kebutuhan beberapa pengunjung yang menuju keblog ini melalui google dengan keyword tentang : -cara mengganti layout facebook -tutorial mengganti layout

Cube Processing for Dimension Schema changes

Hi, I had a general question about how cube processing works. If my dimension schema changes (an addition of a property), will I have to do a full reprocess of all cube partitions for which that dimension was member of? Or do I only need to

Requests for YouTube Backgrounds!

Edit by Mina: Anyone who wants to make a request for a YouTube Background can post here! Please try give some detailed information about your wishes. (fandoms/colors/characters/etc.) Well... Um... I don't have photoshop, and I can't make one...

Type your username with your elbow

DFde n azsdKJGH Holy crap that's the worst I've ever done xD

user title

It gets annoying when people always ask me to change their user title. It would be a good idea if the users can put in there own user title. or activate it for users once they get a certain amount of posts.