Further update to Infocube from DSO was taking long time in the process chain. I killed the Process manually.Set the QM status to red in Process monitor and also red in the Infocube and deleted the request from infocube. I have unfortunately also deleted the request in the PSA and the repeated the delta. I got zero records.
2. So to get the records from the ODS. I have to delete the init request from DSO to Infocube. Then I did init without data.I removed the datamart symbol from the ODS and now I did delta. I got more number of records then expected. Can someone please help me in getting the exact delta from the ODS.