topic Re: Data model ? in QlikView

Data model ?

Wed, 03 Jun 2015 10:49:45 GMT

This data model is good are i should make any changes

Plz Help Me...

Re: Data model ?

hic — Wed, 03 Jun 2015 10:57:58 GMT

Is the Region in the Customers table the same as the RegionID in the regions table? If so, you should link these.

HIC

Re: Data model ?

swuehl — Wed, 03 Jun 2015 10:58:24 GMT

Looks fine to me.

Any specifics you worry about?

Re: Data model ?

Colin-Albert — Wed, 03 Jun 2015 11:09:53 GMT

Two column tables can be replaced using a mapping load.

I would create a mapping table for Shippers and then use ApplyMap to bring the Shippers data into the Customers table.

Similarly if the Region and RegionID fields are the same data, then use a mapping table to bring the RegionDesc into the Customers table as well.

Don't join - use Applymap instead

Re: Data model ?

Wed, 03 Jun 2015 11:30:31 GMT

there is problem in association in customer table and shipper table ( companyname)-( companyname) don't associate you can associate based on ids.

Re: Data model ?

Wed, 03 Jun 2015 11:46:45 GMT

Hi,

It might create problem because customer table and shipper table is connected with companyname field.

use key-fields to connect tables.

Re: Data model ?

pratap6699 — Wed, 03 Jun 2015 12:37:38 GMT

by using applymap() shipper table into merged into customer table and if any relation between region table gegion field and customer table region,,,,if there is any relation change rename to Region to region_ID

Re: Data model ?

Wed, 03 Jun 2015 14:30:15 GMT

Hi swuehl,

My side one thing i want to know is my data model seems to be having association between tables, but it is right model i mean for star/snowflake schema there should be a fact table at the center connecting to all dimension. My model desn't looks like that.

Thanks

Sai ram

Re: Data model ?

Wed, 03 Jun 2015 15:03:18 GMT

Hi,

My side one thing i want to know, for star/snowflake schema there should be a fact table at the center connecting to all dimension is there any rule in qlikview . My model desn't looks like that.

Data in Region in customer table and Region Table Data I am attaching image And also i am attaching one scenario two avoid synthetic keys for customer and supplier table

Re: Data model ?

swuehl — Wed, 03 Jun 2015 15:16:32 GMT

First of all, you should have a look at the attributes which may have the same field name, but are semantically different.

A CompanyName for example could describe a Customer company as well as a supplier company.

These companies probably should not be linked by CompanyName