Best practices in informatica...

Hello All,

We have tried to come up with some of best practices in informatica

• Always try to add expression transformation after source qualifier and before Target. If source or target definition changes it is easier to reconnect the ports

•  Always use Cobol File for normaliser in binary format otherwise there are lot of issues specially with comp-3 fields

•  Remove unused ports, though unused ports do not have any effect on performance bit it is always better to remove them for more visibility

• If possible try to do calculation in Output Ports instead of variable ports as variable ports are need to assign/reassign each time and it can slow down the performance

•  Try to avoid complex filter expression instead of that try to evaluate filter expression in upstream expression transformation and pass it to filter transformation. If you use too many complex calculations in filter condition expression it can slow down performance.

•  In workflow Source/Target directory Property take advantage of Unix links. Instead of hard coding path in source/target directory specify path with Unix link. i.e. suppose in devt environment you are specifying Source directory path as /devserver/team/source and in prod server you specify it as /prodserver/team/source .You can get link created in $PMRootDir in as src_file_dir pointing to /devserver/team/source in dev server and /prodserver/team/source in prod server and in your source/Target file directory you can put path as $PMRootDir/src_file_dir In this case there is no need to change Source/Target directory every time you move between production and dev and testing

• In sequence generator do not connect current value port to downstream (unless required) transformation as when we connect current value port from sequence generator transformation Informatica Server processes one row in each block. We can optimize performance by connecting only the NEXTVAL port in a mapping .

• Improve lookup performance by putting all conditions that use the equality operator ‘=’ first in the list of conditions under the condition tab.

• Always remember rule not to cache look tables having more than 550000 rows (Assuming row size 1024) .If your row size is less than or more than 1024 then adjust number of rows accordingly .

• Avoid calculating same value again and again. Instead of that store it in a variable use it several times.