This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
new Data warehouse for Retail Sales and snowflakes design
Posted on 2011-09-06
Dear all
I will start to create my first data warehouse.
All my work will be with SQL Server 2008 R2, SSIS, SSAS, SSRS
I will start by Retail Sales, I did read the part of retail sales from “The Data Warehouse
Toolkit Second Edition the Complete Guide to Dimensional Modeling” for Ralph Kimball
So far the data warehouse structure is clear for me but there are some points I want to clarify.
What is the advantage and disadvantage of the snowflakes? (Example Product and Sub category and the Category) if I didn’t use the snowflake how will I show this data later in the cube.
thanks,
I will start to create my first data warehouse.
All my work will be with SQL Server 2008 R2, SSIS, SSAS, SSRS
I will start by Retail Sales, I did read the part of retail sales from “The Data Warehouse
Toolkit Second Edition the Complete Guide to Dimensional Modeling” for Ralph Kimball
So far the data warehouse structure is clear for me but there are some points I want to clarify.
What is the advantage and disadvantage of the snowflakes? (Example Product and Sub category and the Category) if I didn’t use the snowflake how will I show this data later in the cube.
thanks,
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
It just changes how your fact data rolls up in SSAS - when you're building your SSAS project, you can define dimension hierarchies, but some of them will be defined for you if you're using a snowflake layout because Visual Studio will see how the data is supposed to roll up based on your dimensions.
Here's a Technet chapter talking about dimension granularity and how to create rollups, which a snowflake layout makes a little easier:
http://technet.microsoft.com/en-us/library/ms166573.aspx
Here's a Technet chapter talking about dimension granularity and how to create rollups, which a snowflake layout makes a little easier:
http://technet.microsoft.com/en-us/library/ms166573.aspx
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar.
Int…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month4 days, 17 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
636 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.