Best way to eliminate synthetic keys?

[varunreddy]

Hi Guys,

Is it better to eliminate synthetic keys in loader qvw or transformer qvw.

For example,

I have 3 tables. I am loading and storing them into QVD in same qvw.

Load * from tableA

Store A into A.qvd

Load * from tableB

Store B into B.qvd

Load * from tableC

Store C into C.qvd

When I reload I get synthetic keys.

Is it better to eliminate synthetic keys in this qvw or in the transsformer qvw (created using qvd)?

[#2]

Hi,

Depends on modeling .. It may be concatenate table, linktable or field concatenate..

Regards

Marcos Freire

[varunreddy]

Which is the best way of creating datamodel?

[quwok · Accepted solution]

This would depend on personal preference and your data source.

Generally, applying them in your transformation layer would make your life simpler since you do not have to do it at every QlikView document using the QVD. Also this would give you an opportunity to standardise and tidy up the naming of columns. But, as always there are exception and you may want to put it in your report data model.

[quwok]

There is no best, it will depend on your data source and requirements. If there was one, everybody would be using it and life would be so much simpler.