Dear all. This is the first time I work with BI7 so I might be asking something obvious , but for me, the issue I am facing is quite strange, I hope someone can help me.
I am loading Falt file to ODS. First to PSA with an infopackage and then from PSA to ODS wit a DTP.
I have set the DTP to be Delta and with "execute delta only once" (well I tried also without this option).
My issue is that when a file has an error and the DTP fails (integrity check if a characteristic), then next files are also failing becuase the DTP is extracting also the previous request from PSA (or from tenporary storage, I am not sure), so the same error happens even when I am loading a new file without issues.
IS this situation normal? Am I doing something wrong?
I have solve the issue by know, by deleting the full PSA before loading a new file, but this is not what I want since I want to keep old PSAs at least for some time. The fact that the DTP in delta mode is bringing more than just the latest request is anoying me.
Thanks a lot in advance,
Alfonso.