Does anyone know of a way to limit the data used on an integrity check in the IDT.
I will explain - unfortunately we do not have a test database so all universe design must be done against the live one. This causes us an issue when checking the integrity as it checks against the entire database which contains 5 years worth of data and amounts to over 9 million rows per month approx 540 million rows used for integrity checking. This takes quite a long time 😔
If anyone knows of any way we can limit the amount of data used I would be very grateful, if it has to be some sort of parameter or command that can be added just for checking and then removed that will be acceptable