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 and what types of fact tables is there

Answer Posted / chandrasekar

A Fact table contains unique combination of dimensional keys.
Fact tables are normalized.
A Fact tables have the facts at the lowest level of granularity.

Types of Fact table:
There are 3 types .
1)Detailed Fact table
2)Aggregate/Summarize fact table
3)Factless fact table

If it wrong means please send the correct answer to me
chandranmca2007@gmail.com

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by blocking transformation?

1015


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7014


How to go to the older version for a mapping?

1066


What are ETL Tools?

1096


What is main use of mapplet?

1119


What are the mapping parameters and mapping variables?

1153


Is it possible to revert a global repository to local one and why?

1063


Define filter transformation?

1078


Explain the etl program with few examples.

1029


How would you copy the content of one repository to another repository?

995


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2376


How many dimensions are there in informatica?

1066


Where do we use mapping variables in informatica?

1043


What is mapping debugger?

989


What is InformaticaPowerCenter?

1112