topic How to Perform my .qvw in QlikView

How to Perform my .qvw

Anonymous — Mon, 22 May 2017 19:24:56 GMT

I have a hard work to do, i need improve my .qvw files, decrease them ,remove the synthetic key, among other things

One thing i realized , and i don't know how to resolve is synthetic key...Some table are linked a other by two field, and if i dont make a left/right join a synthetic key is created.

I dont wanna do left join because It takes too long to update, and concatenate make a synthetic key....

Anyone can tell me how i can remove synthetic key without get worse my code?

Some good pratic...

I have a lot .qvw to analyze, And I know that there's a way I can reduce a lot of processing and memory...

Re: How to Perform my .qvw

Digvijay_Singh — Mon, 22 May 2017 19:36:47 GMT

I suggest you to read relevant information here on link table. Didn't understand how concatenation is causing synthetic key. It would be great if you can share your data model. See some links for your reference

Re: What is link table?

Re: How to Perform my .qvw

Peter_Cammaert — Mon, 22 May 2017 20:01:37 GMT

Removing synthetic keys is often easy to accomplish. The easiest solution is to create composite keys by concatenating all key fields into a single new field (please do use a separator character like '-' or '|' between field values) and either renaming or removing the original fields altogether.

That last action may pose a problem, as keys linking multiple fact tables may be easy to create, but many times none of the fact tables contain all key values and their related information. A solution for this could be to concatenate fact tables together, or create a Link Table with all composite key field values, and a few dimension tables that contain the corresponding details.

Re: How to Perform my .qvw

Siva_Sankar — Tue, 23 May 2017 03:54:36 GMT

Here you can see the most liked discussion on Synthetic key issues Should We Stop Worrying and Love the Synthetic Key?

-Siva