Validating the model

View previous topic View next topic Go down

Validating the model

Post  dbadwh on Tue Nov 29, 2011 9:45 am

Hi,
Is there a quicker way to validate the data model?

dbadwh

Posts : 31
Join date : 2011-09-30

View user profile

Back to top Go down

Re: Validating the model

Post  BoxesAndLines on Tue Nov 29, 2011 10:02 am

How are you validating it now?
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Re: Validating the model

Post  dbadwh on Tue Nov 29, 2011 1:37 pm

Manually checking each dimension, facts and relationships. Cross verifying with Functionality and so on.
But just want to know any other validation mechanism where we can validate it quickly. And I need it currently.

dbadwh

Posts : 31
Join date : 2011-09-30

View user profile

Back to top Go down

Re: Validating the model

Post  BoxesAndLines on Wed Nov 30, 2011 1:32 pm

Given an existing database target, you can "complete compare" a model against the database tables and view the differences. If it is a new model, the model should be validated against a source to target specification. You can also build into the modeling tool rules to ensure the correct data types and lengths are chosen as well as indexes, constraint names, table names, and column names. Unfortunately, there's no way to validate that what is modeled is actually "correct" in that in meets its intended purpose without someone looking at it.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Validating the model

Post  dbadwh on Fri Dec 02, 2011 12:44 pm

Actually I want to validate the logical model, which is little bit big enough. It is very tedious to find how each tables are linked and whether the linked correctly, satisfying the cardinality and granularity. If there is a quicker method or process to ensure the correctness at least to some level, it would be great. Since, we can be little bit confidence .

dbadwh

Posts : 31
Join date : 2011-09-30

View user profile

Back to top Go down

Re: Validating the model

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum