Cache Calculator

Use the cache calculator for aggregator, joiner, rank, and sorter transformations to improve performance.

Select to calculate the total requirements for a transformation based on inputs. The cache calculator requires different inputs for each transformation. You must select the applicable cache type to apply the calculated cache size. For example, to apply the calculated cache size for the data cache and not the index cache, select only the Data Cache Size option.

The cache calculator estimates the cache size required for optimal session performance based on your input. After you configure the cache size and run the session, you can review the transformation statistics in the session log to tune the configured cache size.

Note: You cannot use the cache calculator to estimate the cache size for an XML target.

lookup SQL override for avoid text filed cache

The override sql needs to be in the session because of the performance issue.  If the sql only in the mapping, when create the lookup cache, powercenter will include the CHARGE_VAL_TXT in the order by (sorting). The follow sql in the session will avoid the issue.  This override is there to avoid cache.

pmrep ObjectImport conflict problem

When I do pmrep ObjectImport -i , try to import a folder to another informatica repository. I got a object conflicts error for a User-Defined Function. Originally I got control file from PowerCenter help. Then I did research find out you need add

<TYPEOBJECT OBJECTTYPENAME="User Defined Function" RESOLUTION="REPLACE"/>

or replace with all

 <TYPEOBJECT OBJECTTYPENAME="ALL" RESOLUTION="REPLACE"/>

 Hope this help