topic Re: Removing synthetic key in a preceding load in QlikView

Removing synthetic key in a preceding load

Anonymous — Tue, 08 Dec 2015 10:45:17 GMT

I have read a number of articles which show one how to remove synthetic keys in simple loads. I however have a preceding load with a SQL SELECT statement as i am getting my data from Microsoft SQL Server. I have tried removing synthetic keys through the aforementioned readings on the internet with failure. How can i remove synthetic keys with an SQL SELECT preceding load for the following:

FDAPlatformsfGrowth is being loaded through a preceding load with a MSSQL Server SQL SELECT and DimProduct is being loaded from an Excel file.

Thanking you in advance.

Re: Removing synthetic key in a preceding load

raman_rastogi — Tue, 08 Dec 2015 10:55:55 GMT

Synthetic Keys

you can use SQL aliases to temporarily rename a table or a column heading.

or you can make composite key of conman fields .

Re: Removing synthetic key in a preceding load

Anonymous — Tue, 08 Dec 2015 10:56:04 GMT

Thank you all, i managed to do it to my surprise using a composite key on the three common fields.

Regards.

Re: Removing synthetic key in a preceding load

Anonymous — Tue, 08 Dec 2015 10:56:40 GMT

Rename/Comment/Delete/Composite Key for following fields in these tables DimProduct/FDAPlatformGrowth:

ATCLevelTwoCode as ALTC

ATCLevelThressCode as ALTCC

and so on ..

Re: Removing synthetic key in a preceding load

Anonymous — Tue, 08 Dec 2015 10:57:47 GMT

Thats what, it all depend on your requirement.

To avoid synthetic keys, these are the basic operations:

Rename/Comment/Delete/Composite Key

Re: Removing synthetic key in a preceding load

Anonymous — Tue, 08 Dec 2015 11:11:35 GMT

Many thanks, renaming/comment/delete will not do as they are required for table linking

Re: Removing synthetic key in a preceding load

Anonymous — Tue, 08 Dec 2015 11:28:59 GMT

I said these are the alternates to avoid synthetic key including Composite Key, it all depends on your requirement...which one you would like to do