when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

what is incremental data aggregation?

3 Answers   IBM,

---

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

What do you understand by SOA of Informatica?

0 Answers  

---

design of staging area?

0 Answers  

---