How Master Data Management And Big Data Relate

Master data is basically a shared master copy of data such as customer, product, employee, suppliers and location data used by several applications within an enterprise. Master Data Management (MDM) is important to organizations today because it allows an enterprise to have a single version of the truth. Without a clearly defined master data, any [...]

By |2016-10-31T14:21:27+00:00March 30th, 2015|Big Data|3 Comments

How To Kill Silently Running Orphan Process Flows In 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 [...]

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

Big Data And Hadoop – Features And Core Architecture

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 [...]

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

Data Integration Techniques And Their Challenges

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 [...]

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

Creating ODI 12c Repositories Using RCU Utility

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 [...]

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

Convert Legacy System Data Into Oracle ERP System

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 [...]

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

Data Modeling Basics And Tools For 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 [...]

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

Taking A Dive Into Data Quality Assessment Approaches

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 [...]

By |2016-10-31T14:21:27+00:00February 22nd, 2015|Miscellaneous|2 Comments

Mistakes To Avoid In Bottom-Up Datawarehouse Development Approach

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 [...]

By |2016-10-31T14:21:28+00:00February 22nd, 2015|Data Modeling, Miscellaneous|0 Comments