cancel
Showing results for 
Search instead for 
Did you mean: 

duplicate records in delta load?????pls help!!!! will assign points

Former Member
0 Kudos

Hi all,

I am extracting payroll data with datasource 0hr_py_1 for 0py_c02 cube.

I ran full load with selection crieteria in infopackage -01.2007 to 02.2007, extracted 20,000 records and then

i ran init of delta without data transfer, extracted 0 records as expected.

then ran delta with selection crieteria in infopackage -02.2007 to 01.2010, extracted 4500 where the FEB month records are extracted again.

what could be the reason for duplicate records to occur in the delta load?

i have seen the same records in full load with selection crieteria 01.2007 to 02.2007 as well as in selection crieteria 02.2007 to 01.2010. What and how it is possible?

Actually the datasource 0hr_py_1 datasource is not supporting delta. apart from this what other reasons are there for occuring duplicate records? plss help!!!!!!!!!!!!!!

Will assign points.

Accepted Solutions (0)

Answers (2)

Answers (2)

h_senden2
Active Contributor
0 Kudos

I don't know exactly, but maybe you need to delete all entries from the target source first ?

regards,

Hans

Please reward all helpful answers !!!!!

naveen1241
Participant
0 Kudos

ur selection criteria -

01.2007 to 02.2007 as well as in selection crieteria 02.2007 to 01.2010

both of ur selection includes the month- .02.2007

might b all selections come under .02.2007

hav u checkd tht?

Regards,

Naveen Natarajan