Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are the types of dimension tables

Answer Posted / chandrasekhar naidu

totally 9 types in dimensions
1.CASUAL DIMENSION
2.JUNK DIMENSION
3.DEGENERATED DIMENSION
4.SLOWLY CHANGING DIMENSION
5.SLOWLY GROWING DIMENSION
6.RAPIDLY GROWING DIMENSION
7.DIRTY DIMENSION
8.CONFIRMED DIMENSION
9.ROLE PLYING DIMENSION

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What according to you might be the future of data warehousing?

1029


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?

1110


How to limit the max no of rows retrieved in the report?

986


What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5651


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

926


What is data analysis? Where it will be used?

989


What a static and local variable?

1083


For faster process, what we will do with the universe?

993


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1076


In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?

1050


What are vaious etl tools in the market?

1008


Explain vldb?

1038


What is the difference between olap and datawarehosue?

961


Define data warehouse?

1048


Explain hybrid slowly changing dimension?

1011