Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---

What is a candidate key?

7 Answers   CTS,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

What is the sequence generator transformation in informatica?

0 Answers  

---

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---

What is an active transformation?

0 Answers   Informatica,

---

COM components can be used in Informatica

0 Answers  

---

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

---