Wednesday, March 13, 2013

How Important is Datatype conversion in Informatica?

Data type conversion might look simple but this can play a role in the performance of a session.When you do unnecessary conversion of datatype from varchar to number and then back it create more load for the Informatica server and hence can slow down the workflow.So its better to avoid such conversions and do it only if neccessary else avoid doing such conversions
Another intresting point htat i would like to point out is that ,sometimes datatype conversions can also improve the session.For example in situations where you use Lookup Transformations and Filter Transformations its better to use the integer quantities for condition.So in such situation if we have any string then its better to convert them into integer so that it will speed up the session

No comments:

Post a Comment