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 ?

What is meant by target load plan?

0 Answers  

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

What do mean by local and global repository?

0 Answers  

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

---

Define Incremental Aggregation?

2 Answers  

---