Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Handling deletes when Using BICC to extract PVOs
Harishma
Rank 3 - Community Apprentice
We are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics. Noticed that BICC Application Data Extracts only captures updated and new records, but doesn't capture deletes. Full table loads is not a sustainable solution as the data continues to grow.
We figured that Active Primary key extracts, will provide the list of all primary keys in a PVO. Using this, we are performing soft deletes in our warehouse.
However we wanted to understand if there are any other approaches to identify deletes? (was trying to check if there's any column that can indicate if a row is deleted, but couldn't identify one). Can FA provide deleted records data that will help downstream processes including OBIA?
1