About Kumar Gauraw

Kumar Gauraw is senior IT professional with over 16 years of experience while serving in various capacities at Fortune 500 companies in the field of Data Integration, Data Modeling, Data Migration and architecting end-to-end Datawarehousing solutions. Kumar has strong experience in a wide spectrum of tools and technologies related to BI and Data Integration.

How To Kill Silently Running Orphan Process Flows In OWB

By |2016-10-31T14:21:27+00:00March 8th, 2015|OWB|

In Oracle Warehouse Builder (OWB), not being able to deploy a process flow because it is running in the background is common. The following error message is usually thrown in control center when trying to deploy a Process Flow : where xxx is the name of the Process Flow package. For Example, I [...]

Big Data And Hadoop – Features And Core Architecture

By |2016-10-31T14:21:27+00:00February 28th, 2015|Big Data|

The term Big Data is often used to denote a storage system where different types of data in different formats can be stored for analysis and driving business decisions. Big Data is an assortment of such a huge and complex data that it becomes very tedious to capture, store, process, retrieve and analyze it with [...]

Data Integration Techniques And Their Challenges

By |2016-10-31T14:21:27+00:00February 27th, 2015|Data Integration Concepts|

Data Integration is the combination of technical and business processes used to combine data from disparate sources into meaningful and valuable information. The process of Data Integration is about taking data from many disparate sources (such as files, various databases, mainframes etc.,) and combining that data to provide a unified view of the data for [...]

Creating ODI 12c Repositories Using RCU Utility

By |2016-10-31T14:21:27+00:00February 25th, 2015|ODI|

When I was learning ODI, coming from Informatica and OWB background, it was a totally new tool with new concept. I was looking for some help online and came across some very helpful people and sites that helped me gain confidence quickly. My goal with this article is to share some of that knowledge with [...]

Convert Legacy System Data Into Oracle ERP System

By |2016-10-31T14:21:27+00:00February 24th, 2015|Data Integration Concepts|

When a new ERP implementation is planned, it is usually a well planned, multistage process. Based on my experience of converting legacy data into Oracle E-Business Suite, I am going to share a few things about this process. By the way, I have spent about 7 years of my life converting legacy data into Oracle [...]

Data Modeling Basics And Tools For Data Modeling

By |2016-10-31T14:21:27+00:00February 24th, 2015|Data Modeling|

If you have been working in IT industry for a while, you should have a basic understanding of data modeling concept. The primary goal of this post to share a few basic concepts around data modeling and also to discuss what are different types of data models you should be aware of. What Is Data [...]

Learning About Exchange Partition Mechanism – Oracle

By |2016-10-31T14:21:28+00:00February 22nd, 2015|Oracle|

If you have been involved in creating and managing ETL (Extract, Transformation and Load) processes for datawarehousing environments, you know how time consuming it can be especially when data volume is high. One of the best features in Oracle data warehousing is the ability to swap-out standard Oracle tables and partitioned tables. If you are [...]

Fundamentals Of Big Data And Hadoop Ecosystem

By |2016-10-31T14:21:28+00:00February 22nd, 2015|Big Data|

Big data, as the name suggests, is a collection of large datasets that any organization puts together to serve specific analytical goals and to support their operations. The concept of Big Data is often used to denote a storage system where different types of data in different formats can be stored for analysis and driving [...]