cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate records when writing data to Direct update DataStore object

Former Member
0 Kudos

All,

I am using APD to write query output to direct update DSO .

As Direct update DSO doesnt allow duplicate record to write the Jobs is failing.

I have tried with setting the query with Eliminate the Blank Value etc...

Is there any option which you can ignore duplicate records while writing data to Direct update DSO ??

Reddy

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I have the same problem. Any solution

Former Member
0 Kudos

Hi Rob,

Please use the aggregate function of APD to aggregate the data before loading.

Thanks,

Mayuri

m_verbaan2
Active Participant
0 Kudos

-oops- can't delete...

m_verbaan2
Active Participant
0 Kudos

Hi Reddy,

I guess the only way is to overwrite the complete DSO content (1st option on tab Target area in APD). This is how I do it and works fine.

Hope this helps!

Grtx

Marco