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

2. What functional area you worked on.

1913


What are the different types of reports present in cognos?

571


Can you define query studio?

573


1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

3105


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

1652






How can I schedule reports in cognos?

597


What is main difference mapplets and mapping?

570


----------------------What are the User Securities?

1462


what are the dimensions that you have in your current project?list them?

1599


How security is concerned with Reportnet? Explain its implementing steps.

1614


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.

1625


What is the use of powerhouse?

614


What do you mean by drill across?

580


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1714


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

1644