Removing synthetic key in a preceding load

[Anonymous]

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.

[raman_rastogi]

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 .

[Anonymous]

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

Regards.

[Anonymous]

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

ATCLevelTwoCode as ALTC

ATCLevelThressCode as ALTCC

and so on ..

[Anonymous]

Thats what, it all depend on your requirement.

To avoid synthetic keys, these are the basic operations:

Rename/Comment/Delete/Composite Key

[Anonymous]

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

[Anonymous]

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