Ranjan Gupta

About Ranjan Gupta

This author has not yet filled in any details.
So far Ranjan Gupta has created 5 blog entries.

32 Tips for Oracle SQL Query Writing and Performance Tuning

By | May 8th, 2015|Oracle|

I am working with Oracle SQL from day when I joined IT industry and I have been fascinated by number of things I have learned about SQL, different databases and its usage over the years. In early phase of my career, I learned that writing SQL queries was not just about writing but writing so [...]

Taking A Dive Into Data Quality Assessment Approaches

By | February 22nd, 2015|Miscellaneous|

Data Quality plays a crucial role in the success of a data warehouse. End-users expect that the data residing in the data warehouse database will be accurate and reliable. Failure to meet these expectations will result in a loss of confidence in the data warehouse by the end-users. Once end-user confidence is lost, the data [...]

Mistakes To Avoid In Bottom-Up Datawarehouse Development Approach

By | February 22nd, 2015|Data Modeling, Miscellaneous|

There is a vigorous debate going on since the advent of datawarehousing in the DW community about whether to build applications top-down or bottom up. The model often requires implementation of numerous, large, normalized, relational target databases, including a central data warehouse, Operational Data Store, Persistent Staging Area, and additional databases, such as an Exploration [...]

How to Select an ETL Tool For Datawarehousing

By | February 22nd, 2015|Data Integration Concepts|

Selection of an appropriate ETL tool is the most important decision that has to be made in choosing components of a data warehousing application. The ETL tool operates at the heart of the data warehouse, extracting data from multiple data sources, transforming the data to make it accessible to business analysts, and loading multiple target [...]