Following are the differences between OLTP and OLAP:
OLTP:
Data is from original data source
Simple queries by users
Normalized small database
Fundamental business tasks
OLAP:
Data is from various data sources
Complex queries by system
De-normalized Large Database
Multi-dimensional business tasks
Have you handled Management Information Systems or Cost Analysis or variance Analysis?
How do you manage budgets? At your previous employer what steps did you take to cut costs?
Define the functions of a load manager?
Which language is used for defining Schema Definition?
What kind of costs are involved in Data Marting?
How many dimensions are selected in Slice operation?
What in your terms is ideal operations management team?
What is the very basic difference between data warehouse and operational databases?
Out of star schema and snowflake schema, whose dimension table is normalized?
Which one is faster, Multidimensional OLAP or Relational OLAP?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
