topic Synthetic key during Partial load in App Development

Synthetic key during Partial load

Cbhuvi27 — Fri, 15 Nov 2024 20:58:07 GMT

Hello All,

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

Re: Synthetic key during Partial load

mpc — Sun, 19 May 2024 16:20:11 GMT

Hi,

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

Kind regards

Re: Synthetic key during Partial load

Cbhuvi27 — Sun, 19 May 2024 16:33:42 GMT

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

Re: Synthetic key during Partial load

mpc — Sun, 19 May 2024 16:45:44 GMT

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 ?