topic Re: Data Modelling in QlikView

Data Modelling

Wed, 26 Aug 2015 11:54:20 GMT

Hi,

I'm trying to build data model. I've 280 table and there are some columns in each table. And most of the tables has same column names.

Loaded some ten tables, I see there is a synthetic key table was created. I see there some possible ways to eliminate synthetic key

Renaming fields (Using QUALIFY)

Removing fields

Please let me know which is best possible way to create link between all the tables.

Attaching the file for reference.

Thanks,

Srikanth

Re: Data Modelling

vikasmahajan — Wed, 02 Dec 2015 05:12:08 GMT

did you got any solution !!

Re: Data Modelling

engishfaque — Wed, 02 Dec 2015 05:15:15 GMT

Dear Srikanth,

I would recommended you to create link/bridge table.

Kind regards,

Ishfaque Ahmed

Re: Data Modelling

vikasmahajan — Wed, 02 Dec 2015 05:16:34 GMT

Ishfaque Ahmed Since from many days you are not active on community ? where are you ?

Re: Data Modelling

prma7799 — Wed, 02 Dec 2015 05:18:38 GMT

Please go through below link

Synthetic Keys

What is the use of link table?

Re: Data Modelling

ychaitanya — Wed, 18 Apr 2018 18:00:32 GMT

Try to concatenate most similar tables and create a FACT LESS FACT Table and then perform the LEFT KEEP on the remaining DIMENSION Tables which will link to FACT and create a STAR SCHEMA.

This method definitely helps and is quite achievable .

Hope this helps

Thanks