Service Operations Insight

 View Only
  • 1.  Truncating Staging Tables

    Posted Oct 05, 2016 09:04 AM

    Hi Guys


    I have pulled data into my staging tables but I tried purging some of the data but the status still says staging in progress. It has been saying that fro quite some time now. What will happen if I go ahead and truncate the staging tables when there is data not migrated from the staging tables.


    There is also other data that is still in the staging area and wanted to know what will happen if i truncate the tables.




  • 2.  Re: Truncating Staging Tables

    Posted Oct 05, 2016 01:16 PM

    Hi David,

    I believe all that data will be lost

  • 3.  Re: Truncating Staging Tables
    Best Answer

    Posted Oct 05, 2016 01:45 PM

    The truncate command removes all data from the staging tables. So any data that has not been migrated will be lost. Running the truncate ‘resets’ the tables and frees up disk space. Ideally Data Manager would do this on its own but only if the system reports all data are migrated and no staging/pull jobs are running. If a job gets ‘hung’, it can stop this process. Therefore it is advised to truncate the staging tables to resolve this state (again data not migrated will be lost). The SQL for the truncate commands are in the Data Manager admin guide. You can use CCR gap reports to find how far back you need to go for a catch-up pull after truncating.



    Kip Lamb

    Sr Principal Consultant, Presales

    CA Technologies | Bellevue, WA 98005

    Office: +1 512 776 0235 | Mobile: +1 425 591 4358 |





  • 4.  Re: Truncating Staging Tables

    Posted Oct 05, 2016 03:52 PM


    Have we answered your question?