Query in data modelling design

[qlikviewforum]

I have load the FACT table first then I have LINK table then I am planning to concatenate some data to FACT again which contains the key field that exists in the LINK table(But the KEYfield which is there in the LINK table is not from the FACT table).

So my question is will there be any impact if I try to concatenate some data to FACT table after the creation LINK table(As mentioned above KEY field which exists in the LINK table is not coming for FACT).

Please let me know if there is any issues with this approach. If anything is not clear please let me know.

[Chanty4u]

Hi

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

[jonathandienst]

I am not sure if I understand you correctly, but normally the key field is generated from some combination of fields that should exist in the fact table (or at least the source of the fact table), so you would normally generate the values using the same logic as used to create the key field in the link table. If the underlying fields are stored in the link table (as is usually the case), then drop the underlying fields from the new fact lines. You may want to do this all in a temp table and concatenate to the fact when done.

[qlikviewforum]

Thanks for sharing the documents. That will be really helpful for me.

If you can answer for my query that will be very helpful for now since understanding issue after reading all the documents will take more time.

[qlikviewforum]

Thanks for you response.

I didn't get you completely.Yes the KEY field is created based some combination for fields that exists in the FACT as well as in LINK table but the KEY field which is there in the LINK table is not from FACT table. So my question was if try to concatenate some data to the FACT after the creation of the LINK table will there be any issue? Hope my question is clear now?

[jonathandienst]

If the key values for the new fact lines already exist in the link table, then you need do nothing to the link table as the new facts will automatically associate with the existing keys. If they do not, you will need to concatenate additional rows to the link table with the new key values along with their related fields.

[qlikviewforum]

Thanks again for your response. As I mentioned KEY field which exists in the LINK table is not been fetched from the FACT table so is there is any impact in my case if I try to concatenate the data to the FACT table after the creation of the LINK table. Please let me know if you have any questions.