topic Data model in QlikView

Data model

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We are having Fact and Dimension Tables.

For Ex: Fact table has 10 fileds and Dimension table has 20 fields.

After loading these tables we got synthetic keys of 10 keys.

Please let me know the right way to resolve this.

Thanks,,

Re: Data model

Anil_Babu_Samineni — Fri, 20 Oct 2017 10:48:19 GMT

Start search by your self in google. There is 100+ threads related on Synthetic keys ..

Re: Data model

Mark_Little — Fri, 20 Oct 2017 10:49:28 GMT

Hi,

Could you supply more information.

The most likely cause is you have multiple fields with the same name in your fact table and Dimension table.

There should only be one field which is the key between the fact and dimension, any other fields with the same name should renamed or removed in the script.

i.e.

Field AS Dim.Field,

Mark

Re: Data model

mithilesh17 — Fri, 20 Oct 2017 11:42:07 GMT

Hi,

Pls go through

Re: Perfect Your QlikView Data Model

Regards,

Re: Data model

Anonymous — Fri, 20 Oct 2017 12:25:30 GMT

Hello,

take a look at these post:

What is synthetic keys? How it can be avoided?

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

Synthetic keys >> sometimes a good idea?