Mohd Azharuddin Ansari

I was reading the articles about the technical architecture role and responsibilities and found some interesting pieces of information so thought to share with you all.  In this post, I will try to capture some of the techniques and terms commonly use in software architect and ask in interview. 1.        SOLID Principals a.        Single Responsibility Principal – Class should have only one responsibility. b.       Open Closed Principal – Open for extension but closed for modification. c.       Liskov Substitution Principal – Covariance and Contarvariance. d.       Interface Segregation Principal – Client should never be forced to implement the interface that it doesn’t use e.       Dependency Inversion Principal – Entities must depend on abstraction not on concretions. 2.        CAP Theorem – It’s a concept that ...

If you are planning to display a logging image on a time consuming task on a web page then this post will help you in doing this. You can make this happen only by following below simple steps Step 1 CSS     .overlay {     background: #e9e9e9;       display: none;             position: absolute;        top: 0;                       right: 0;                     bottom: 0;     left: 0;     opacity: 0.5;     }   #loading-img {     background: url(../Images/Loading.gif) center center no-repeat;/*Add the loading image that you want to show*/     height: 100%;  ...

SSIS Merge Join Issue ( Both inputs of the transformation must contain at least one sorted column, and those columns must have matching metadata SSIS )   I was working on one of my client requirement where I need to split the flat file data based on the conditions and then add join that data with reference data (again a flat file). I used the MergeJoin task to achieve this. Unfortunately I ended up with this error. I tried most of the options available on the internet but none of them worked for me because my mistake was silly I set a property of “Sort” task in one not the other. That’s why MergeJoin was throwing “ Both inputs of the transformation must contain at least one sorted column, and those columns must have matching metadata SSIS ” error.     Lets first discuss about the solution of my problem Root Cause – The main problem was related to the Sort task. I selected the “Comparison Flags” option in one Sort task but not in other task because of that M...