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

how can we calculate fact table size?

Answer Posted / venkateshmalneni

A fact table is multiple of combination of dimension tables

ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores

3*365*200*200=fact table size

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1802


without table how to come first record only in oracle?

2261


How might one distinguish in the case of mapping is right or not without associating session?

1131


How to update or delete the rows in a target, which do not have key fields?

1181


What is the session task and command task?

1064


How can we remove the duplicates from flat file source?

1045


Briefly define a session task?

1140


What is a grid in Informatica?

1076


Briefly describe lookup transformation?

1047


Explain the code page compatibility?

1074


What are the measure objects?

1211


How do you load unique records into one target table and duplicate records into a different target table?

1268


What are the types of caches in lookup?

1052


what is song in infrmatica...?

2240


Explain scd type 3 through mapping.

1023