Export Setup Table Data

Export data from the Data Integration setup tables.

Use the Export Setup Table Data option to export the data from the following tables for debugging purposes:

  • AIF_BALANCE_RULES
  • AIF_BAL_RULE_PARAMS
  • AIF_LCM_ARTIFACTS_V
  • AIF_SOURCE_SYSTEMS
  • AIF_TARGET_APPLICATIONS
  • AIF_TARGET_APPL_DIMENSIONS
  • AIF_TARGET_APPL_PROPERTIES
  • TPOVPARTITION
  • TBHVIMPGROUP
  • TBHVIMPITEMFILE
  • TPOVPERIOD
  • TPOVPERIODADAPTOR
  • TPOVPERIODSOURCE
  • TPOVCATEGORY
  • TPOVCATEGORYADAPTOR

To run the Export Setup Table Data script:

  1. Click Application, then Jobs, and then Schedule Jobs.

  2. From the Schedule Jobs page, then What type of job is this?, select Integration Maintenance Script.

  3. To schedule an integration maintenance script to run now, see Scheduling Hourly Jobs .

    To schedule an integration maintenance script to run later, see Scheduling a Data Rule or Integration Definition to Run Later in the Job Scheduler.

  4. Click Next.

  5. From Integration Maintenance Script page, click Image shows Select icon. to the right of the Export Setup Table Data task to schedule.

  6. From the Export Setup Table Data page, review the job parameters and click OK.