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

Answer Posted / tanveer ahmed

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 ?    30 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What DB View and Bus View?

1542


What is the difference between ‘macro’ and ‘prompt?

551


what are the features in cognos8ui

1563


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1720


What are all the types of hierarchies?

674






hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

1596


What is a Folder?

681


I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.

1624


How is cognos model organization works?

598


Can you define a query subject?

603


----------------Describe DWH Architecture?

1652


New coloums are added in database, then how you know in report level

1160


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

1952


What is a dimension?

631


Which lifecycle we will use for reporting?

565