topic Re: Please suggest in QlikView

Please suggest

Thu, 24 Sep 2015 06:40:34 GMT

I have couple of tables A and B with huge amount of data .These table are associated with a Link Table C which is associated with Master Calendar Table D with Date field

So which of the option will give better performance in my qvw

1. Remove the Link Table C and concatenate both the table A and B to generate a new table E with their respective Date fields and associate that with Master Calendar Date Field

2. Keep the Data model as it is

Re: Please suggest

Anonymous — Thu, 24 Sep 2015 06:43:35 GMT

please can you post structure of datamodel

Re: Please suggest

SreeniJD — Thu, 24 Sep 2015 06:43:48 GMT

Hi Binod,

Is your data model is snow flake?

If Yes, then use link table to concatenate your tables.. as snow flake will cost more resources than your link table.

Happy to help!

Sreeni

Re: Please suggest

Thu, 24 Sep 2015 07:35:32 GMT

Hi,

Can you share your data model

Thanks