Portal

Hello Virginie,

You want to register the statistics from previous sessions ? Or are you looking for a way to log statistics each time a mapping is executed ?

Hi Virginie,

If your needs is to register statistics for each execution of your mappings : You'll have to create a common process that will insert statistics in your centralized stats table.

This process will simply use some input variables in SQL query.

Then you will be able to use this common process on your existing process just after your mapping step.

You will have to specify the good values on that common process. Stambia will put this values on the SQL query and will execute the good insert statement on your centralized stats table.

This is an example of common process :

Here, I use a table named STATS_TABLE with some fields (TABLE_NAME, CHAIN_NAME, NB_INSERT, NB_UPDATE, NB_DELETE).

On the existing process, this is the way you will use the common process (by drag and drop) :

You see differents usages to put the good values of your statistics :

- The first one is the most simple use case that will perform sum of SQL_STATS. You just have to specify the name of the step that you want to get statistics. This solution will use light rhino script (very light).

There is a limit of that solution if your mapping perform a LOAD step, your statistics could be wrong because the number of inserted rows will be higher.

- The second solution is to specify the complete path of your mapping insert (or update) step. So, Stambia will get the real statistics. But this solution is a little more complicated because writing the complete path of steps could take time.

Remember you can add every information that you need to register on your centralized stats table (date, session_id, etc...). You just have to change SQL query on the common process.

If you want to register previous sessions statistics, you'll have to read log database. I suggest looking at this following tables :

- stb_log_session_sess to get session informations

- stb_log_session_stat_sst to get all session statistics

- stb_log_action_stat_ast to get all session step statistics

- stb_log_action_s_act to get session step informations

Hello Virginie,

This is the two tables usage : 

The first table (stb_log_action_stat_ast) contains every step (act_id) executed on a session (sess_id). Each of the lines contains volume statistics (type of statistic acp_short_name and the value ast_stat_sum).

If you want to get the name of the step, you'll need to use the second table (stb_log_action_s_act) which contains name of the step (act_short_name), and the path (act_parent_path).

I suggest doing several tests to validate that you are using the correct values. It all depends on what you want to retrieve in your table that centralizes the statistics.

Hi Virginie,

Sorry for the delay.

• If you want to get statistics during an execution of a process (for instance to get statistics for several mappings or step already executed) you have to use my first method described in this post (with the path of statistics steps) : This statistics is stored after the steps have ended but the sessions can still be running. However, if you want to get statistics for ended sessions, you can use database log. 
• The table stb_log_action_act contains start (act_begin_date) and end (act_end_date) timestamp for every steps.
• About the database log model, I sent you an email with specific information. It's important to know that our teams are working on different articles including one that concerns this subject.