You can view the data extraction status in SAP from the SAP BW monitor in SAP BW. It shows green for successful data extraction and red for failed data extraction. The SAP BW monitor also shows the following information about data extraction:
Number of packets sent
Number of rows in each packet
Time taken for sending the packets
Start time and end time
If the data extraction fails, you can start the InfoSpoke again to start the data extraction process. You can start the InfoSpoke again only after the PowerCenter Integration Service completes extracting data from the database table and sends the status to the SAP BW monitor.