Answer Posted / sanjay

here i m taking the example of employee table

first use the sorter to get the distinct value....

then use the agg trns, create the output port and use the
count function on employee_id to get the total no. of rows
like.. count(employee_id) and group by employee_id.

create filter trns.. write a condition where output>1... map
it with the target...

What if the source is a flat-file?

1122

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2130

---

While migrating the data from one environment to another environment how would you manage the connections?

1095

---

Explain the types of lookup transformation?

1052

---

What is data caches/ index caches?

1112

---

During the running session, output files are created by informatica server. Enlist few of them.

990

---

What are the different lookup cache(s)?

1128

---

What do you mean by worklet?

1077

---

What is mapping debugger?

1022

---

What are the tasks that can be performed using sq?

1099

---

What does “tail –f” command do and what is its use as an Informatica admin.

1115

---

How to create a non-reusable instance of reusable transformations?

1138

---

What is informatica etl tool?

1006

---

update strategy transformation in informatica

1072

---

In informatica workflow manager, how many repositories can be created?

1371

---