Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Data model

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,,

4 Replies
Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Mark_Little
Luminary
Luminary

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

mithilesh17
Partner - Creator II
Partner - Creator II

Hi,

Pls go through

Re: Perfect Your QlikView Data Model

Regards,