Answer / vino

Mapping performance is nothing but u tune the mapping to
achieve better performnace .

Like to use filter after sq,using sorter before
aggregator,deleting unwanted fields in the lookup etc.....

Answer / nafeeja

Mapping Performance is to tune the mapping for better performance. To achieve this first we need to find out the performance bottle necks at three levels and optmise those.
1) Identifying Source Bottlenecks
2) Target bottleneck.
3) Identifying Mapping Bottlenecks

Differentiate between source qualifier and filter transformation?

0 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?

2 Answers   Span Systems,

---

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,

---

Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

---

---

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

---

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

---

What are the options in the target session of update strategy transsformatioin?

2 Answers  

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

How to get EVEN & ODD numbers separately?

8 Answers  

---

From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

---