It is set on sas base 9.4 and of course the LASR version is 2.8
The system look like this: - every hour, the data is refreshed on other servers in different systems. I created view to have access to them
The question is: What is the most efficient way to update my data?
Requirements: It has to update very frequently (even during the day) and the proces must be very short. The data must be up to date the moment it changes.
My thoughts: I thought of: - using IMSTAT and doing all operations in memory - or just doing it in tables, hash tables and then update the memory I receive data like which rows are to be removed and which to append