Metric Studio 'transfer data from staging area into metric store'

[teraneteurope]

Hello,

Can you run 'transfer data from staging area into metric store' when users enter the data into staging area?? This is really critical for my project. Would much appreciate some pointers.

Thanks

Teranet Europe

 

[blom0344]

1. Staging area is off-limits for anything other than the ETL-engine loading the next level of tables.

2. If users have only read-only rights, than there should be no problem. If they manually load staging tables for some reason, then choose a window where the database can be closed for them and load data. Do not try to load data that may be locked for update/insert..

Ties Blom