Temporary Tables have accumulated and is not dropping from the DB. Why?

• Related Articles

• A lot of temp tables have accumulated in the DB. Why?

  When we execute multi parse KPIs, the temp tables automatically get created and dropped in real-time. Sometimes executing such multi parse KPIs may take longer time and business users might terminate in between because of the time taken. At such ...

• How does ARC Temporary Tables get created?

  When we execute multi parse KPIs, the temp tables automatically get created and dropped in real-time. Sometimes executing such multi parse KPIs may take longer time and business users might terminate in between because of the time taken. At such ...

• How to define sequence or order for tables in dbmodel ?

  You can define the order for aggregate tables through ?sequence?. See the below example..

• What are aggregates/aggregate tables and where is it used?

  When a KPI is published using a set of measures and dimensions, it dynamically refers a specific aggregate table and fetches results from it.

• Do all the aggregate tables specified in data model need to have a sequence number?

  All aggregate tables specified in the 'dbmodel.xml' have to be given a unique sequence number in order to apply the order of execution. And sequence is not just the running number for all tables; it has to be grouped by data mart. Please contact ARC ...