We have a cube in FI. The cube is being loaded with a full load from an ODS. The option of "delete overlapping requests" hasn't been selected in the data target tab of info package. My question is aren't the records getting duplicated every time a full load is done? When I look at the contents of the cube, there are too many records for the one record. I understand that a cube donot addup the records if they are from different packets.but even then having those many records is wrong? Also we are reporting on a particular time period and we are getting the results ok.
My question is do I need to select the option " delete overlapping requests in info cube" or not?