Skip to main content
Jul 20, 2022 7:54 PM UTC
Solved

Loading data Error

I am unable to load data into the database using Update data activity. My schema does not have any primary key as none of the records are unique. So I have declared autopk="true". Here is the workflow

 

Can someone please suggest on how to update such data? Do i need to use

a. "Directly using the target dimension"

b. "Using one or more link"

c. "Using reconciliation keys"

In my case when i don't have any primary key how do i select from the options above.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Manoj_Kumar
Manoj_KumarAccepted solution
Community Advisor
Jul 21, 2022 5:28 AM UTC

@subhra111 

Use the option "Directly using the target dimension" and choose the operation as "insert".

 

Then do the fields mapping and start the workflow.

Manoj  | https://themartech.pro

4 replies

Subhra111Author
Jul 21, 2022 2:49 AM UTC

If I use "Using Reconciliation keys" I am getting the above error. Please help.

 

Translate
Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
Jul 21, 2022 5:28 AM UTC

@subhra111 

Use the option "Directly using the target dimension" and choose the operation as "insert".

 

Then do the fields mapping and start the workflow.

Translate
Manoj  | https://themartech.pro
Marcel_Szimonisz
Community Advisor
Community Advisor
Jul 21, 2022 6:32 AM UTC

Hello @subhra111,

it looks like you have not update database structure.

Tools --> Advanced --> Update database structure

 

Marcel

Translate
Sukrity_Wadhwa
Level 4
Aug 10, 2022 8:45 AM UTC

Hi @subhra111,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Translate
Sukrity Wadhwa