wht is degenerated dimension ?it's uses?

Answer Posted / suba

degenerated dimension is data that is dimensional in nature
but stored in a fact table

Is This Answer Correct ?    40 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of SCD?

706


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?

672


What is difference between query studio and report studio?

617


What are non-additive facts in detail?

630


What is the difference between ods and oltp?

650






How can you communicate with web server (apache or iis) from coldfusion?

645


Could any one explain me how to create cascading prompts?

593


How to performance tune reports?

654


Explain what is data validation strategies for data mart validation after loading process?

689


Explain the data type of the surrogate key?

633


What are snapshots? What are materialized views & where do we use them?

620


How can you import tables from a database?

635


Compare cold fusion with other programming languages?

646


What is junk dimension? What is the difference between junk dimension and degenerated dimension?

692


What is surrogate key? Where we use it?

643