Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Loading data Error

Avatar

Level 1

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

MadhuSree_0-1658346392084.png

 

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.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@Subhra111 

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

 

Then do the fields mapping and start the workflow.

View solution in original post

4 Replies

Avatar

Level 1

Srima_0-1658371715500.png

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

 

Avatar

Correct answer by
Community Advisor

@Subhra111 

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

 

Then do the fields mapping and start the workflow.

Avatar

Community Advisor

Hello @Subhra111,

it looks like you have not update database structure.

Tools --> Advanced --> Update database structure

 

Marcel

Avatar

Administrator

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!