Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to stop extract file creation at BICC in case of no incremental data

Received Response
91
Views
2
Comments

At BICC, First extracts are full table extract. next schedule extracts will generate incremental data files. For these incremental schedules, if there is no incremental data in any scheduling period, we need an option to NOT generate incremental file for that schedule.

Answers

  • User_VUSLW
    User_VUSLW Rank 1 - Community Starter

    We are also checking solution for the same issue. Please let us know if there is any way to restrict generation of data files when there is no data.

    BI Cloud Connector

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    When you run a data extract in addition to your data extract files you will get a MANIFEST file and an EXTRACT_STATUS file. The extract status will list the status of each extract including success or failure, how long it took at each of various stages, how many rows extracted. So if you wish to you can read the extract status file then delete any files you do not want to keep if the rows extracted are zero.