What is surrogate key? Explain with examples.
No Answer is Posted For this Question
Be the First to Post Answer
Explain what are non-additive facts in detail?
How to calculate fact table granularity?
Can we start and stop single session in concurent bstch?
Explain what is a cube in data warehousing concept?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
How to export mappings to the production environment?
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
Explain can a dimension table contains numeric values?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
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?
How can we load the time dimension?
What are the key columns in Fact and dimension tables?