Data Extraction Approach for Oracle tables that doesn't have PVO's
Problem
We need to understand what is the best Data Extraction Approach for Oracle tables that doesn't have PVO's
Came across below approaches:
Approach 1:
Steps:
1. Create a New Data Store
2. Data Store Key: You have to manually enter the full path of OTBI EFF VO: FscmTopModelAM.EgpItemsPublicModelAM.ItemEFFBIFlattenedVO
3. Provide Query Filter as necessary and save
4. You can now select Columns and add the required EFF segments to the data store.
Approach 2:
1. Create BIP report and invoke it to extract incremental data from Oracle SCM but this approach is not recommended as per https://www.ateam-oracle.com/post/using-synchronous-bip-for-extracting-data-dont
Could you please suggest us the best alternative approach?