Data Warehouse Schema consists of Fact Tables and the Dimension Tables. A Fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables. In data warehousing, a Dimension table is one of the set of companion tables … More What are the Data Warehouse Schema Types?
ETL is short for extract, transform, load, three database functions that are combined into one tool to pull data out of one database and place it into another database. Extract is the process of reading data from a database. Transform is the process of converting the extracted data from its previous form into the form … More What is ETL Process? What is a data mart?
According to Gartner Magic Quadrant as of Feb’2015 , Teradata, Oracle, IBM, Microsoft and SAP are clearly the leaders of ETL Tools. The criteria used for the ETL tools comparison are grouped into 12 categories: √ Infrastructure √ Functionality √ Usability √ Platforms supported √ Debugging facilities √ Data Quality / profiling √ Performance √ … More What are popular ETL Tools ? What does Gartner Magic Quadrant as of Feb 2015 say?
We can divide IT systems into transactional (OLTP) and analytical (OLAP). In general we can assume that OLTP Sytems provide source data to Data Warehouses, whereas OLAP systems help to analyze it. – OLTP (On-line Transaction Processing) is characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE). The main emphasis for OLTP systems … More What is OLTP Vs OLAP ?
According to Gartner, Business intelligence (BI) is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance. Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful … More What is Business intelligence (BI)?
The large BI vendors, including SAP, Oracle, IBM, Microsoft, Information Builders, MicroStrategy and SAS, have been around for years. But there are also a number of BI startups that see their products get absorbed as a feature in a larger player’s software. According to EnterpriseAppsToday, in addition to the large players, some mid-size BI vendors to … More What are popular Business Intelligence Tools? What does Gartner Magic Quadrant for BI Tools for 2015 say?
I often see people getting confused between Master Data Management – MDM Vs Data Warehouse – DWH. Here is the difference :
Virtualization has its roots in partitioning, which divides a single physical server into multiple logical servers. Once the physical server is divided, each logical server can run an operating system and applications independently. Virtualization allows you to separate the Operating System from the underlying hardware. Cloud Computing separates the application from underlying hardware. Virtualization … More What is virtualization? Is it same as Cloud Computing?
When you configure the TCP/IP protocol on a Microsoft Windows computer, an IP address, subnet mask, and usually a default gateway are required in the TCP/IP configuration settings. 1.TCP/IP? Is technically a Protocol Suite IP Routes Traffic, it is from Layer 3 OSI Model Network. Routable Networks (sub networks).TCP controls transmission between connected systems, it is … More What is TCP/IP and Subnet Masking?
A server provides services to other computers on a network. A server can be an expensive Windows 2008 Server, or a simple Windows XP Home computer with a shared printer. In information technology, a server is a computer program that provides services to other computer programs (and their users) in the same or other computers. Operating System: … More What is a Server?