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

Data engineering Interview Questions

1)  What all challenges you have faced and how did you overcome from it? Ans:- Challenges Faced and Overcome As a hypothetical Spark develop...