Lookup in informatica

MY PEER GUIDE LINES A static lookup turned to dynamic and back static has issues in the lookup transformation better option is to delete the transformation and recreate it again. and in 7x the lookup override has bug for every column in the lookup overide should be termed AS at the end and this case specially for distinct option inthe lookup override.