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...

-----------Types of Fact Tables?

Answer Posted / abd hfz

There are two types of Fact Tables namely :

1) Cummulative Fact Table : Facts collected over a period
of time are called CFT. This contains mainly Additive facts.

2) Snapshot Fact Table: Facts collected at the particular
time are called SFT. This are mainly Semi/Non Additive facts.

Also,
Fact less fact table : which has only FK and does not
contain any measures. eg: Visitors to the office

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by query studio?

945


What is the difference between Standard and Metrics folder?

1082


How the Bursting happens in same report and how to Print the bursting Report?

1867


What r the names of the reports that you prepared?

981


what is catalog and types of catalogs in cagnos and which is better?

1160


What are the different kinds of panes included in cognos?

1057


What is model?

969


How Metrics Studio is better than Report Studio?

2603


What is Fullouterjoin?

1982


Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2033


in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1910


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2092


When we save a report in report studio with what extn it save?

1066


what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2080


What are the components used in web tier?

992