"A dimension table is wide but the fact table is deep," explain the statement in your own words.
1461What is junk dimension? What is the difference between junk dimension and degenerated dimension?
1112What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
1114Post New Data Warehouse General Questions
in general which algorithms for used?
What is the difference between constraind base load ordering and target load plan?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is data mart in data warehouse?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain bus schema?
Explain what is real time data-warehousing?
What is the difference between connected and unconnected stored procedures?
How we are using this function?
Explain what are slowly changing dimensions?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is your spectra photometer working principles?
Explain what are components of reportnet?
What is perform recovery?