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

SNOWFLAKE Interview Questions 2025

  1️ ⃣ Choosing the Perfect Size of Virtual Warehouse To select the right size (X-Small to 6X-Large), consider: Data Volume ...