Answer Posted / ansari
Fact table: It contains numeric values and also contain
composite key(i.e collection of foreign key) e.g.. sales
and profit.
Dimension table: It contains character values E.g
Customer_name,Customer_city.
| Is This Answer Correct ? | 48 Yes | 79 No |
Post New Answer View All Answers
In document how to create metrics?
What are the various tools? Explain name a few?
What is the working process for application.cfm?
Explain bus schema?
Explain which are the olap tools available that are supported by oracle?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
How can we run the graph? How can we schedule the graph in unix?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain what are the advantages and disadvantages of reporting directly against the database?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Explain what is ods (operation data source)?
How can we schedule the graph in unix?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain what is cost benefit analysis (cba)?
Why facts table is useful in representing the data?