Every hour how much data loaded into each tables
I want to generate a report every hour how many rows inserter into a table. i am trying to aggregare it using LOAD_STREAMS tables. But that table gets cleared every hour.
either I want to extend the retention period of Load_Streams table or any other way to get Loaded row count details in table wise.