I need few clarification on the below items
1. What is the purpose of SID generation setting( Bex reporting) in ODS Setting. I mean what it will do while activating the ODS. Please explain in detail.
2. Will there be an impact on query performance if this setting is not selected for the ODS.
3. Consider the example below
Say there are 3 requestts already loaded to ODS with SID generation setting. Then I remove the setting. After that I loaded the 4th request without SID generation setting.Again I am seleting the SID generation setting for ODS and and loading the 5th request.
My question is that will this generate SID's for 4th request also.
Thanks in advance.