Checking to see if there is a way to create a “current values only” table in RDM, with no historical records to be kept? I don’t see any option for this in the documentation or One Desktop dialogs.
Solved
Is it possible to create a table in RDM that will not keep historical data, just current values?
- Data Voyager
Best answer by AKislyakov
As I mentioned historization is mandatory in RDM. But history values are kept in a separate table, so shouldn’t significantly affect performance of day-to-day operations.
- Ataccamer
Hi
RDM tables are always historized by design. Could you please provide more details about your specific use case for disabling historization in RDM tables?
- Data Voyager
For one particular table we have no use for history, just current values and would like to eliminate historical record processing to minimize the processing load and storage on the server.
Thank you
- Ataccamer
As I mentioned historization is mandatory in RDM. But history values are kept in a separate table, so shouldn’t significantly affect performance of day-to-day operations.
+4- Data Pioneer
You could of course create an export plan where you use as input the current date, so it will filter the data on the current data. Then export it back into another RDM table. Theoretically, that can work, although it seems a bit nasty. Another method that i would prefer more is to create a view of that RDM entity and add a filter where you filter the valid from and valid till fields on the current time/date.
Reply
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.