Question
What is junk dimension? what is the difference between junk dimension and degenerated dimension?

Answers

Junk dimension: Grouping of Random flags and text attributes in a dimension and moving them to a separate sub dimension. Degenerate Dimension: Keeping the control information on Fact table ex: Consider a Dimension table with fields like order number and order line number and have 1:1 relationship with Fact table, In this case this dimension is removed and the order information will be directly store.   Your Comment






Search
Can you Answer!!
  • Q What is the advantages of VB.NET?
  • Q What is Monopolistic Competition?
  • Q Which family,order does the fish Spiny dogfish belongs to?
  • Q What type of settings have you done for web (click & script) protocol?
  • Q What is the difference between extraction and isolation of essential oil or active substances from aromatic and medicinal plants?
  • Q Differentiate between writeoff and receipt writeoff.
  • Q You are with a nurse who takes blood and makes a labelling mistake on a patient who has needle phobia. What do you do? What do you say to the patient and what do you say to the nurse?
  • Q What is the purpose of sprintf() function
  • Q What will be the output of cast ('XYZ' as INT)?
  • Q How can I get Linux for mySAP Business Suite and where ?
  • Q What is the main purpose of Monetary Policy?