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

How do you migrate data from one environment to another?

1041


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1131


What is the use of transformation?

944


What is a sequence generator transformation?

950


Enlist few areas or real-time situations where informatica is required.

1012


What does cheating measurement mean?

994


what is INFORMATICA TESTING process

2223


Differentiate between sessions and batches?

962


lookup transformation with screenshots

3938


On which transformations you created partitions in your project?

1247


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2052


How to create a non-reusable instance of reusable transformations?

1057


what is the complex transformation you used in informatica

2521


I have a flat file, want to reverse the contents of the flat file

1064


Explain pushdown optimization $pushdownconfig parameter - informatica

1078