Synthetic key during Partial load

[Cbhuvi27]

Hello All,

Synthetic keys are getting created when using Partial Load with ADD ONLY. Can someone help to eliminate the synthetic keys.

[mpc]

Hi, 

You can share you script ? This will help us in the troubleshooting process. 

Kind regards

[Cbhuvi27]

Hello,

Load * from

largerqvd(qvd);

Add only

load * from

smallerqvd(qvd);

both the qvd have same data. Basically i n just adding some additional data using partial load

[mpc]

Quite strange, if a Synth key is created, that's mean usually that the structures of teh tables are differents, and then are not automatically concatenate. 

Can you check/share the header of the larger and smaller.qvd please, and share ouput data model Moreove, what is the table output when you do: Add only concatenate load * from smallerqvd (qvd) ? Can you try and share the data model output too ?