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

What is drill-through?

578


What is Discrete and Continuous data in Data mining world?

2122


What is a relationship?

576


How many project sources we can create in metadata?

561


How to test report in reportnet?

570






What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

579


What is the difference between star and snowflake schemas?

601


Database in use is oracle?

604


How we are using this function?

599


What is the difference between constraind base load ordering and target load plan?

650


What is the difference between data warehouse and operational systems?

598


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

553


Explain the main differences between star and snowflake schema?

546


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1728


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

1561