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 informatica worklet?

1072

---

What is a code page?

1182

---

Explain the types of lookup transformation?

1048

---

What do you understand by term role-playing dimension?

1052

---

can u any challenge your project?

2037

---

How can we use batches?

1030

---

What are the new features of informatica 9.x developer?

972

---

difference between informatica 8.1.1 and 8.6

3683

---

What's the layout of parameter file (what does a parameter file contain?)?

2390

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2136

---

How to generate sequence numbers using expression transformation?

1095

---

What are mapplets? How is it different from a Reusable Transformation?

1097

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1084

---

How to do unit testing in informatica?

1180

---

Explain sessions and how many types of sessions are there?

1013

---