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
Explain what is the data type of the surrogate key?
Define Data Warehousing?
What is Sequence clustering algorithm?
Explain what are the basic needs to join two sources in a source qualifier?
What is a Decision Tree Algorithm?
What is drill-through?
What is the goal of optimizer?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain is olap databases are called decision support system true/false?
Why denormalization is promoted in universe designing?
Explain a mapping, session, worklet, workflow, mapplet?
What is the use of incremental aggregation? Explain me in brief with an example?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Describe a data warehouse.
What is the difference between Datawarehouse and OLAP?