OLTP

Entry Point
According to the introduced architecture, our entry point is data of the OLTP nature.
Everything starts here!
Assume a hypothetical organization that collects daily data through its SQL Server (or any other database management system similar to Oracle).
Our Entry Point Based On The Introduced Architecture Is OLTP Data.
First, We Specify The Data Source For Analysis Because Everything Starts Here.

As you saw in the previous figure, we will conduct some analysis on a series of data in the beginning.
This part is called the data source; this data type is a relation (OLTP).
For example, consider a hypothetical organization that collects data daily through its SQL Server (or any other database management system similar to Oracle).
This data is stored in this place over time, and as mentioned, the data may not necessarily be in the same place and maybe scattered in different areas due to the type of business they have.
As an SSAS Specialist, almost all you need to know about relational databases is familiarity with tables, fields, records, and some familiarity with T-SQL.
Elements
In the world of OLTP, there are five basic concepts that we will learn in detail below:
Database
Table
Field
Record
T-SQL
Introducing Resources
Written by: Moslem Afrashteh
Get Exclusive SSAS Tips
That I Only Share With
Email Subscribers