What is an OLTP (Online Transaction Processing) System?
Answer Posted / 9885657928
A olap is a specification which allos the client
applications in retreiving the data from following the sources.
1.A relational data warehouse
2.Multidimentional database
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the main steps to build the data warehouse?
Where the cache files stored?
What is the very basic difference between data warehouse and operational databases?
Explain what are non-additive facts in detail?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are partition points?
What is the difference between static cache and dynamic cache?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
How to provide security in frame work manager for a query subject?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How can you import tables from a database?
What is the difference between power center & power mart?
What are parallel querys and query hints?
What are various warehousing tools?
Explain a mapping, session, worklet, workflow, mapplet?