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 is fact table?

Answer Posted / p.suneetha roy

A central table in a data warehouse schema that contains
numerical measures and keys relating facts to dimension
tables as primary key present in Fact table for the
uniqueness and foriegn keys coming from dimension tables
referring to fact table. Fact tables contain texture data
and section.

There are 4 types of facts :
1)Additive
2)Non Additive
3)Semi additive facts
4)Factless fact.


Let me know if there are any more facts.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we create a Integration service without a Repository service and vice versa?

1204


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1068


How to load the data from people soft hrm to people soft erm using informatica?

995


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2012


What is an unconnected transformation?

1067


What is difference between a gateway node and worker node?

1115


What is a connected transformation?

1097


3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2228


What is native users?

1139


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5760


If informatica has its scheduler why using third party scheduler?

1246


Design a mapping to load a target table with the following values from the above source?

1327


server hot-ws270 is connect to Repository B. What does it mean?

2534


On which transformations you created partitions in your project?

1323


Describe data concatenation?

1062