What is the difference between Oracle Express and Oracle
Discoverer?
Answer / abc
Oracle Express is a Multi Dimensional Database where as
Oracle Discoverer is a reporting tool
| Is This Answer Correct ? | 6 Yes | 1 No |
5.Explain ODS ?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
What is data stream and data adaopter. Is it same are different? Explain?
Where we use surrogate key explain with example?
How to load the time dimension?
What are the advantages and disadvantages of reporting directly against the database?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What needs to be done when the database is shutdown?
The same tier?
Why should you put your data warehouse on a different system than your oltp system?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Compare aggregates and data marts