wht is degenerated dimension ?it's uses?

Answer Posted / msb.dwh

degenerated means a dimension key is add to facttable for
grouping the date transactionly but there is no table

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to reduce warnings?

618


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

616


Explain what is the advantages data mining over traditional approaches?

690


What are the mapping paramaters and maping variables?

640


Explain what is the data type of the surrogate key?

657






What is data validation strategies for data mart v?

645


What are various warehousing tools?

659


Explain the differences between normalizer and normalizer transformation?

603


What is the difference between olap and oltp?

636


What are the different types of join operations?

642


What is metadata in context of a datawarehouse?

625


What is a core dimension?

704


Explain conformed fact?

609


What is the goal of optimizer?

660


What is metadata in context of a datawarehouse and how it is important?

654