Answer / gyana ranjan behera

SESSION LEVEL PERFORMANCE TUNING

(1)SET YOUR SESSION TO RUN IN BULK MODE
(2)DO SESSION PARTITION
(3)INCREASE COMMIT INTERVALS
(4)CHECK THE INCREMENTAL AGGREGATION
(5)DTM BUFFER SIZE MUST BE IN BETWEEN 6MB TO 128MB
(6)BUFFER BLOCK SIZE 4KB TO 128KB

Answer / vinay kumar

set properties of mapping tab set bulk loading option in sesstion then performs is increasng..........but sometimes session is failed, the session is no reusable
tht is an drawback

Answer / sehaj

MR GYANA RANJAN BEHERA.....CAN U TELL ME WHEN WE ARE USIN
SESSION IN BULK MODE THEN WHAT IS THE NEED OF SETTIN D
BUFFER BLOCK SIZE ?

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

What is the fact table?

0 Answers  

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

Briefly define reusable transformation?

0 Answers  

---

How to convert flat file into xml file? How to tune joiner?

2 Answers   Accenture,

---

what is scd?

6 Answers  

---

What is the difference between a shortcut of an object and copy of an object? Compare them.

3 Answers  

---