Interested to Buy Any Domain ? << Click Here >> for more details...
wht is degenerated dimension ?it's uses?
- 10 Answers
- 52419 Views
- CTS, Infosys, I also Faced
- E-Mail Answers
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
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What are the approaches used by optimizer during execution plan?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is the 4 + 1 view model as it relates to system modeling?
What are the methodologies of data warehousing?
What are the types of partitioning?
if you use oracle sql*loader , how do you transform data with it during loading?
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?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain which are the olap tools available that are supported by oracle?
After the complete generation of a report who will test the report and who will analyze it?
What is conformed fact?
What are the difference between snow flake and star schema?
Can decision tree be implemented using SQL?
