Anand Tech Blog

Today I cleared the part 2 exam of TOGAF and clearing it has been a big relief. Was working on Togaf part 1 for almost 6 weeks and couple of more weeks for part 2. Part 2 is little simpler compared to part one is my feeling and if you have worked as software architect it helps further. On the preparation front, I took the Udemy course by Scott on TOGAF part 2, the course material is about 2 hours. The main takeaway there is how to identify the solution that is irrelevant. There are 4 possible solution to the case scenario, and grading is like 5 for the right one, 3, 1, and 0 for the distractor. The idea is identify the wrong one quickly and they move between them to identify the right one. The exam is an open book and you have know little bit how the material is organized. For practice test, I purchased the sample question from opengroup.org and practiced it couple of time. Part 2 test has only 8 questions and with 90 minutes to complete, looking at it seems like lot of time, but ...

Recently one of the projects I was architecting went live. All the data that was stored in an excel sheet prior to this project was be ported to a DB. Data was loaded to lower environment multiple times and the real data was loaded to Staging Database prior to production. The story is good so far. On the day of production, the same data was copied from Excel and uploaded to production with help of DBA and his scripts. When the data was verified next day, to my horror, we discover couple of rows with junk characters at the end of primary key. The excel sheet had couple of white spaces in the end for that column, it is a mystery how it got converted to special characters. A production CR  was created to delete the row, then a new set was to be added with additional rows that were not in production. The second round of data upload was to take place using ETL too. I was little at peace with this approach as the insert would happen only to the batch table and then it will moved to ...