Answer Posted / shree uday
Junk dimension: A junk dimension is a collection of random
transactional codes, flags and/or text attributes that are
unrelated to any particular dimension. Simply to say a
randomly used dimension is junk dimension
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain which are the olap tools available that are supported by oracle?
How many types of facts and what are they?
What is the use of dimensional modeling in data warehousing?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What does level of granularity of a fact table signify?
Explain some of modeling tools available in the market?
What is dimension modeling?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain meta data?
Which columns go to the fact table and which columns go the dimension table?
Explain which columns go to the fact table and which columns go the dimension table?
Explain what are the advantages data mining over traditional approaches?
How to create different types of templates?