At last, I had my second covid jab the day before Yesterday😁 After the first shot I didn't feel any side effects at all. Yesterday I was really sick but today I'm ok again.
And I'm still working on my old Data warehouse. After all this years. I several times thought I left it behind, but no it is still there hauting me on it's 21 year of operation. I recently found two broken disks in the database raid 6. Not fun, it became even worse when Dell told me they did not have any replacement disks for the old database server. Luckily I found a company selling refurbished disks. Later I found out Dell did have larger disks perfectly ok as replacements. The Dell representative I spoke to probably didn't know. Anyway now the old Irons are good as new.
I'm working on reducing wallclock time for the nightly batches and eliminate different kind of errors. Right now I'm looking at posibilities of inject error correction code in the SAP data extraction engine. Normally this kind of processing is done after extracting data from Source systems, but this time it is not possible. A very clever guy has created an entire data warehouse engine inside one one ITL script. Really ingenious, but sort of closed, the extraction of data from SAP into the Data Warehouse is done in one go (actually in 25 parallel independent threads).
