Tenant refresh

nihal-krishna

Hi All,

We are following our standard procedure of tenant refresh from Production to another lower tenant. During this process due to large amount of data the total time taken for import of tables alone would take around 35 hours which includes incremental load of two tables i.e., MIATTR & QMSRQT and the remaining tables are imported as a whole. Just wanted to know if there are any other alternative step which can reduce the total time taken for the import of data.

Thanks & regards,
Nihal S Krishna

elise-falk

Do you maintain MOATTR & MIATTR with ATS990? The first checkbox gets rid of temporary attribute records, which aren't used for anything after the fact. Just that reduced the size of our MOATTR by 90%, and we have it scheduled as a daily job now. Believe it does the same for MIATTR. We also don't do any incremental loads, which I think keeps it a little speedier.