0 Replies Latest reply: Mar 14, 2012 5:38 AM by 913073 RSS

    How to identify the status of the data load

    913073
      Hi All,

      Here is my requiremenet,

      I have a process called etl_pf2 which loads the data into staging tables. Now I have another process that does a partition exchange and moves the data from staging tables to online tables.

      In one procedure, I need to verify whether any data load into the staging tables is happings. If yes then partiontion should not occur, if no then movement should happen.

      Any idea on any parameter which can be used in the procedure to check the status of the data load in staging tables.

      Please help me.