OLAP and OLTP
Explain the following term: a) OLAP b) OLTP
Explain the following term:
a) OLAP
b) OLTP
Expert
OLTP:
In case, an on-line operational database system is utilized for the proficient retrieval and storage and management of the huge amounts of data, then the system is known as on-line transaction processing.
OLAP:
Data warehouse systems serves users (or) knowledge workers within the role of data analysis and decision-making. Such systems may organize and represent the data in several formats. These systems are called as the on-line analytical processing systems.
Explain the term Contexts?
What are the main tasks of a Server?
Describe the reserving of memory using a declaration statement in data structure?
Provide a brief differentiation between independent and dependent data warehouse?
Why we use Context? And explain the LOV?
Specify the System variables?
How can we do unit testing into the informatica? How to load data in the informatica?
Justify whether all the Business Objects users build the data providers?
Write down a short note on the Global Temporary tables (GTT).
Define the term merge stage?
18,76,764
1958588 Asked
3,689
Active Tutors
1426312
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!