See here: Understanding Generation Data Sets
I had never a use case where I considered generation datasets advantageous. I find it much easier to work with tables that got a date component in the name like base_name_<yyyymmdd>.
If you then need all the data for a month you just use syntax like: set Tran_May_202405:;
I consider working with generation datasets especially cumbersome when there is a need for a reload - which is absolutely no problem with table names that got a date component in it.
... View more