after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls?

[#1]

after developing datamodel?how do i came to know that my data model is perfect?tell me some tips to cross check? pls?

[sasikanth]

HI

Read the Follwing post,How to test your Data Model,

6 ways to Test your QlikView application

One basing thinhg is cross checking with the data base, By firing Queries at database side...

[matthewjbryant]

Hi,

The two ways I find the most helpful are:

• Pick out random examples to check within your application
• Look for and interrogate any duplication in the data

[datanibbler]

Hi,

I tend to go the pragmatic way about those things:

=> Your datamodel is "perfect" - good, that is - when it works and the results you get are correct. The "best practices" are all interesting and helpful and can help you make your datamodel slimmer and more efficient in terms of resource_usage - but generally, when it works, you're ok. You can go from there.

One thing to look at closely is your keyfields - a key in a masterdata_table should always be unique, not so in a transaction_table.

Best regards,

DataNibbler

[vardhancse]

once the data model was done,

we need to validate the data from the data source

based on the metrics we can use queries and can can validate the data

we need to identify the data flow, so that accordingly we can load the data.

we can use left keep/join so that only relevant data can be loaded.

shortly if data was validated from the data source, our data model was good

[#6]

how to validate the data

[vardhancse]

based on metrics we need to validate in db using queries

[#8]

what is meant by metrics u are frequently using that word?

[vardhancse]

metrics are nothing but.

These are used expression we will use in the charts for calculations.

Agent_No     Agent_Name

1                  ABC

2                  BCD

# of agents(Metric)