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

What is the function of union transformation?

1137


How does the aggregator transformation handle null values?

1150


What is an aggregator transformation?

1099


What is the different lookup cache(s)?

1088


Performance tuning in UNIX for informatica mappings?

2570


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1088


What is rank transformation in informatica

1179


Define mapplet?

1016


waht type of interface is used for testing the data in informatica

2259


Can u generate reports in Informatica?

1091


Enlist the tasks for which source qualifier transformation is used.

1041


Explain pushdown optimization $pushdownconfig parameter - informatica

1149


What is the difference between Active and Passive transformation?

1153


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1786


what are the Methods For Creating Reusable Transformations?

1177