Answer Posted / rohit

I have below records.

EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-

101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship

What is meant by target load plan?

968

---

What is the Rank index port in Rank transformation?

1051

---

Which transformation should we use to normalise the COBOL and relational sources?

1199

---

Can you use flat files in Mapplets.

2648

---

where to store informatica rejected data? How to extract the informatica rejected data?

997

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1052

---

How do you change a non-reusable transformation to reusable transformation?

994

---

Define mapping and session?

1031

---

which one is better performance wise joiner or look up

1086

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2141

---

Differentiate between source qualifier and filter transformation?

1572

---

Explain what is informatica metadata and where is it stored?

1044

---

What is decode in static cache?

1171

---

How we can create indexes after completing the load process?

1154

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2315

---