Thursday, December 4, 2014

How to Optimize Buffer Memory in Informatica

How to Optimize Buffer Memory in Informatica

1)Buffer Block Size

Buffer Block Size = Largest Row Precision * 100

2)Session Buffer Blocks

Session Buffer Blocks = (total number of sources + total number of targets) * 2

3)DTM Buffer Size

DTM Buffer Size = Session Buffer Blocks * Buffer Block Size / 0.9




1 comment:

  1. Thank you so much for explaining this concept with mathematical formulaes and solutions.This indeed is really helpful.

    Informatica Read Soap API

    ReplyDelete

ADF functions

 toString(JT_DEAL_PLAN_EFF_DT, 'MM/dd/yyyy HH:mm:ss','es-ES')