The only difference between the two is the level of normalization of your dimension table(s); think of star schema as of denormalized snowflake schema.
Here is an example:
Employee dimension is linked to Employee_Earnings fact table by Empl_id.
Let's say each Employee has atributes like Dept...
I see a flow in this DataMart design, particularly in the Region table; Origination & Destination should just be attributes in the Region table.
You would need two records in your dimension table (Region) and a computer generated key to fix the flow, and to track trips in both directions . Your...
blom0344, I could share your humor ...
I was half serious half kidding when I asked those questions. Those interviewers who came up with those damn questions are either trying to use inteviews to collect innovative ideas or to fail everyone on purpose.
While I've been developing reports on a...
These are some of the questions I was asked on the interview. My opinion is that all of them are to trick you into a wrong answer. Try to answer them without looking up in BusinessObjects - if you're not dealing with reports 7x24 but you answered all corectly than you're a real guru ...
1. How...
Can this be done by setting up some property? I cannot find any in Report or Universe ...
(using application.interactive = false in VBA cannot be used)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.