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...

if we increase the number of dimensions will the rows in
fact table increase or decrease??

Answer Posted / itesh

Yes, if we increase the dimension obviously that key need
to added in the fact ,

Ex

1 fact joined 1 dim of 4 key,
I have added 1 dim with 2 keys

Now my fact will be 8 keys.

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of fact tables used in data warehousing?

940


What is the difference between aggregate table and materialized view?

1031


What are target types on the server?

940


What should I have in mind when building olap solution from scratch?

925


How many types of facts and what are they?

951


Explain what are the methodologies of data warehousing?

868


What is Active Datawarehousing?

953


What is critical column?

1111


Explain why fact table is in normal form?

918


What is metadata in context of a datawarehouse?

969


how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2086


What is Operational Data Store?

1004


Explain the difference between dw and bi?

967


What is the difference between er modeling and dimensional modeling?

1075


Explain what is the advantages data mining over traditional approaches?

973