makeing a stand for star schema design
lconsalvo at 03h45
25
Aug
2010
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 about mortgage servicing data that is provided by two vendors, with different layouts. At this point the details of the requirements may be irrelevant. My impression of the organization is
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 about mortgage servicing data that is provided by two vendors, with different layouts. At this point the details of the requirements may be irrelevant. My impression of the organization is
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
I am a beginner if a Database is given how we can achieve a Star schema design?
Can you please provide me an update.
thanks Vel
There is currently a difference of opinion on how the EDW should be structured for ad-hoc reporting. One camp suggests that the dimensional design can easily support both ad-hoc and analytical reporting. While the other suggests that the dimensional
Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?
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
I'm designing a data mart for employee compensation. The measures will include things such as salary and various bonuses.
Most of the data marts I've designed so far have fallen rather gracefully into a star schema. For this one, however, I have
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
See also
Informations
3 Replies For the topic :
"makeing a stand for star schema design"
This topic has been viewed 2317 times.
Last message :
25/08/2010 at 03h45 by "lconsalvo"
