Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,

---

In any project how many mappings they will use(minimum)?

1 Answers  

---

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

Define Incremental Aggregation?

2 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

Define enterprise data warehousing?

0 Answers  

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

In which scenario did u used Mapping variable?

1 Answers   Cognizant,

---