DATAWAREHOUSE CONCEPTS- TOP 10 TOPICS OF 2014

This post is just a recap of the most discussed topic in Dwhlaureate for the year 2014.

1. VIRTUAL COLUMN IN ORACLE 11G 
   Virtual Column is one of the new features introduced in Oracle 11g….. 

2. OBIEE 11.1.1.7- New Features 
   OBIEE 11.1.1.7 has been released by Oracle and they included more than two hundred enhancements, designed to add new functionality for improved performance and deliver an enhanced end user experience….. 

3. Hierarchical Retrieval In ORACLE or Hierarchical Queries 
   There is provision to display the reporting pattern in an organization….. 

4. Invisible Indexes - Oracle 11g New Feature 
   Before 11g, Oracle didn’t have the facility to make an Index Invisible or visible…… 

5. “ VoltDB ” - NewSQL DBMS For High Velocity Applic... 
   VoltDB is a high performance scalable RDBMS and NewSQL Database primarily for Big Data, high velocity OLTP and Real-time analytics designed by…… 

6. Introduction To NewSQL 
   NEWSQL is a new class of Databases products that offers high performance and scalability like NoSQL for online transaction processing and also 

7. What is Massively Parallel Processing (MPP) With the advent of Big Data sets mainstream technologies like Massively Parallel Processing (MPP) systems is experiencing vital growth…. 

8. Oracle Database 12C New Feature-Fetch& Offset 
   In this post we will discuss about a new feature that was introduced in Oracle 12c to limit the rows returned in an easier and effective manner compared to methods …. 
   
   
9. How to Unlock the Locked Table in ORACLE 
   Oracle puts locks while performing any DDL or DML operation on oracle tables. When table locks is present on any tables in Oracle we cannot run DDL on those tables. 

10. Informatica Scenario: How to Load Data in Cyclic Order 
    In this scenario we will load the records present in the DEP table to Flat files in a cyclic order such that the first record will go to TargetFile01 ,2nd to TargetFile 02 ,3rd to Target File03 and 4th record again to TargetFile01. 
    
    
    
    
    If you like this post, please share it on google by clicking on the Google +1 button.
    
    
    Please go through our latest post TOP 6 BIG DATA TRENDS IN THE NEAR FUTURE
    
    

Differences between Datawarehouse schema and RDBMS schema?

RDBMS Schema	DWH Schema
Used in OLTP system like banking	Used for OLAP systems
Its Normalized using either of the normal forms	Its De normalized
Its difficult to understand the tables and understand in User perspective	Easy to understand and mainly used for data analysis and extracting the data.

Difference between OLAP & OLTP

OLAP stands for Online Analytical Processing.

It uses database tables (fact and dimension tables) to enable multidimensional viewing, analysis and querying of large amounts of data. E.g. OLAP technology could provide management with fast answers to complex queries on their operational data or enable them to analyze their company's historical data for trends and patterns.

OLTP stands for Online Transaction Processing.

OLTP uses normalized tables to quickly record large amounts of transactions while making sure that these updates of data occur in as few places as possible. Consequently OLTP database are designed for recording the daily operations and transactions of a business. E.g. a timecard system that supports a large production environment must record successfully a large number of updates during critical periods like lunch hour, breaks, startup and close of work.