Accenture Interview Question

LO Extraction process, how to retrieve failed records both from source system and staging layer in BI