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 / maya

THERE ARE 3 TYPES OF FACTS
1)ADDTIVE:FACTS THAT CAN BE SUMMED

2)SEMI ADDITIVE:FACTS THAT CAN BE SUMMED UP FOR SOME OF THE
DIMENSIONS AND NOT OTHERS.
EX:BANK BALANCE
3)NON ADDITIVE:CAN'T BE SUMMED.
EX:RATIO,AVG,VARIANCE
------------------------------------------------------------
----------There are two types of Fact Tables namely :

1) Cummulative Fact Table : Facts collected over a period
of time are called CFT.

2) Snapshot Fact Table: Facts collected at adhoc basis are
called SFT.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is there any comparison available for cognos reportnet vs crystal reports?

906


What are all the components of Report Studio?

1041


WHAT ARE THE DISTNICT VARIABLES?

2177


Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1006


Write various indexes used in cognos?

921


What is meant by Reportstudio shortcut?

2126


Can you define cognos impromptu?

978


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1960


Give me any example of semi and non additive measures?

899


How do we convert from Numeric to be Words?

2937


What is defined as Query studio?

1024


hi my name is siraj i want to know cognos queriy language

2213


can you tell me what are the dimension tables are used in project

2250


What is cognos powerhouse?

975


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1941