Answer Posted / ratna

Performance tuning is a trail and error method. By using the session Log we would like to know where the bottle neck is. For each session DTM processor creates one reader, one transformation and one writer thread will create. In session log we can find Buzzy time. which is having the highest buzzy percentage that where the bottleneck present. We have to over come this by using the performance tuning Technics.

What are the different versions of informatica?

1265

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2125

---

What are the limitations of joiner transformation?

1109

---

Briefly define reusable transformation?

1127

---

What are the different components of powercenter?

1050

---

Is there any way to read the ms excel datas directly into informatica?

1022

---

How we can create indexes after completing the loan process?

1206

---

What is a transaction control transformation?

1204

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

---

how many types of dimensions are available in informatica?

1092

---

What are the types of caches in lookup?

1048

---

What is lookup transformation?

1040

---

How can you validate all mappings in the repository simultaneously?

1368

---

What is the meaning of up gradation of repository?

1983

---

What is xml source qualifier transformation in informatica?

1217

---