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.
Solved! Go to Solution.
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'.