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

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1563


What are the differences between datamart vs. Reporting cube?

499


Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

512


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

578


How to join 3 database like flat file, oracle, db2 in informatrica?

657






What are the difference between snow flake and star schema?

520


what type of raid setup would you put your tx logs?

537


What according to you might be the future of data warehousing?

537


What is normalization, first normal form, second normal form, third normal form?

543


Explain degenerate dimension table?

552


Is union transormation is active transformation?

596


How to import vsam files from source to target. Do we need a special plugin?

519


How much data hold in one universe.

563


How to reduce warnings?

532


Explain er diagram?

559