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

What are the advantages of informatica?

1058


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2199


How to load data in informatica ?

1068


Explain dynamic target flat file name generation in informatica

1109


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1112


differences between service based and product based?

2060


What are mapplets? How is it different from a Reusable Transformation?

1136


What are the databases that informatica can connect to windows?

1096


tell me the rules and responsblites in our project(my project is development)

1977


Differentiate between joiner and lookup transformation?

1159


Performance tuning( what you did in performance tuning)

2055


What are the different transaction levels available in transaction control transformation?

1274


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1530


can anyone explain me about retail domain project in informatica?

7999


How does a rank transform differ from aggregator transform functions max and min?

1263