Full Coverage on Data Integration Tools and Technologies

Whether you are a newbie in the field of Data Integration or a seasoned professional, we want to engage with you.

If you are here to learn, we have plenty of guides for you on Datawarehousing, Data Modeling, Database Concepts, ETL Tools and much more. Check out our blog topics and guides and we are sure you will love what you will see here!

If you are an experienced professional and wants to share your knowledge with the world to add value, we need you. You can contribute to our blog and build your personal brand as an expert! The more you contribute, the more you will learn and also grow your personal brand as a professional.

Data Integration Tools and Technologies Covered At DI Ninja Blog

From Basics To Advance: Wide Spectrum of DI Topics

We continuously publish articles, videos and how-to guides to add value to our readers on a regular basis. Check out some of our latest topics.

When Complete Compare On Corrupt Data Model Crashes Erwin

By | January 17th, 2016|Categories: Data Modeling|Tags: , , , , |

According to the CA help documentation on Erwin, Cut, Copy and Paste functions are fully supported. You could simply select model objects you want to copy and paste them into a new or existing model [...]

Actually, Spark Adds Power To Hadoop In Real-Time Processing

By | January 5th, 2016|Categories: Big Data|Tags: , , , , |

Since Apache Spark came to existence in 2014, it received massive recognition and developer community just loved it, all for good reasons. Apache Spark is a fast, in-memory data processing engine with elegant development APIs [...]

How To Load Star Schema Dimensions And Facts In Parallel

By | December 19th, 2015|Categories: Data Integration Concepts|Tags: , , , , , , |

One of the bottlenecks often encountered in ETL development for start schema is the sequence of loading dimension tables before being able to load any fact table. Obviously, it happens since fact tables need those [...]

Using Oracle’s Partition Exchange Load for Very Large Target Tables

By | September 15th, 2015|Categories: Oracle|Tags: , , , , , , |

The situation is very common in Data Integration where a good performing ETL load starts to slow down. The job that been running and loading data just fine, suddenly becomes too slow and becomes a [...]

The Relationship Between Data Quality and Master Data Management

By | May 27th, 2015|Categories: Miscellaneous|Tags: , , , , , , , |

Master Data Management (MDM) is the process of creating and managing quality data in such a way that an organization can have a single master copy of its master data; such as customer, product, items [...]

Dimensional Modeling for Support Ticket Processing

By | May 19th, 2015|Categories: Data Modeling|Tags: , , , , , |

Dimensional modeling becomes challenging, sometimes in uncommon situations, or that are not straightforward. Dimensional modeling with multiple stages of processing can sometimes be confusing and difficult. Such is the nature of a ticket-based support system [...]

Benefits and Limitations of Using Virtual Columns in Oracle Database

By | May 9th, 2015|Categories: Oracle|Tags: , , , |

As the name suggests, Oracle introduced the concept of defining columns on a table that will actually not store values. Instead, it is uses an expression based on other columns in the same table. A [...]

32 Tips for Oracle SQL Query Writing and Performance Tuning

By | May 8th, 2015|Categories: Oracle|Tags: , , , |

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

CA ERwin-Using Naming Standards, Model Templates

By | May 1st, 2015|Categories: Data Modeling|Tags: , , , , , , , |

Data Modeling (Relational or Dimensional,) is a job that needs more thinking than really doing. It has more to do with gaining a better understanding of business processes and data that follows through those processes [...]