degenerated means a dimension key is add to facttable for grouping the da

wht is degenerated dimension ?it's uses?

Question Posted / msb.dwh

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

Please Help Members By Posting Answers For Below Questions

Explain the definition of normalized and denormalized view?

836

What is the difference between drill through and masterdetail reports?

1056

What is the goal of optimizer?

1004

What is a Decision Tree Algorithm?

4948

Explain what is the difference between datawarehouse and bi?

906

Where we use surrogate key explain with example?

1047

What are vaious etl tools in the market?

939

What are aggregate tables and aggregate fact tables?

964

Explain reference cursor?

2113

Why we use repository connectivity?

923

Explain what is the difference between a primary and secondary actor in use case modeling?

1017

Can we start and stop single session in concurent bstch?

888

What are the data marts?

917

How would you write a left join statement to return a result set of movie.title�s and director.name�s?

971

What is data cleaning? How can we do that?

983