---------- Purpose of Factless Facttable?
Answers were Sorted based on User's Feedback
Answer / kalyani
According to Kimball
"Factless fact table are the preferred method of recording
the events in the DW where there is no natural numeric
measurement associated with the event. Factless fact tables
also are used to gurantee coverage"
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kalyani
A factless fact is a fact table in which only primary keys
of the dimension tables present as foreign keys but no
individual fact clomuns.
| Is This Answer Correct ? | 1 Yes | 3 No |
Can you define materialized view?
What is the difference between macro & Parameter
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
Can you define metrics designer?
how to perform back drill through in cognos 8 what is the use of it
what is online view?
-----------Diff b/w OLAP and RDBMS?
how many types of formats you can run a report using cognos?
hi Cognos Experts Pls Expalin me what is the diffence between list report query and crosstab report query?pls explain me.....
what does my folder and public folder contains? difference between the my folder and public folder?
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day