Tuesday, September 29, 2020

BI/DW Best Practice #15 - Be careful to be pilot project

The application defeats and stability of the tools using always impact to our projects. So, try to avoid them as much as possible.

Major released version is usually one of the scenarios. I am not saying to stick in the old version tools. It is ok to use the new version after a few success use case from some projects with proper scale. I mean that we can use new version but don't be pilot. It is because the major defeats are not likely reported nor fixed before the first few success use cases.

I would also recommend following the common use case of tools. For example, a tool may work well in window platform with massive use cases. It may also supports Linux but has limited use cases. Let says SQL Server. I would recommend using it in Window platform but not Linux. It is the same idea, platform related defeats are reported and fixed after plenty of use cases. You may sometime think that Aix and Linux are similar platform and try to your the applications to Linux. I won't recommend unless there are massive similar use cases in the market.

No comments:

Post a Comment

Extract: Performance Tips

Below listed some common performance tips for extract queries. Extract required columns only and specify in the query, avoid select * Extrac...