Data Modeling

When Complete Compare On Corrupt Data Model Crashes Erwin

By | January 17th, 2016|Data Modeling|

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 diagram without any problem. You can read more about this functionality here: https://supportcontent.ca.com/cadocs/0/CA%20ERwin%20Data%20Modeler%20r9%205-ENU/Bookshelf_Files/HTML/ERwin%20Help/index.htm?toc.htm?Cut_Copy_and_Paste_Functions.html However, the development community seems to be [...]

Dimensional Modeling for Support Ticket Processing

By | May 19th, 2015|Data Modeling|

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 where a single ticket can go through multiple stages and multiple people. So, how do you do dimensional modeling for [...]

CA ERwin-Using Naming Standards, Model Templates

By | May 1st, 2015|Data Modeling|

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 than knowing a bunch of technical terms or tools. However, having a good technical handle on tools like CA ERwin [...]

Data Modeling Basics And Tools For Data Modeling

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

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