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...

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7266

---

How do you convert single row from source into three rows into target?

1090

---

What are mapplets?

1211

---

What is meant by target load plan?

914

---

In warehouses how many schemas are there?

1010

---

What is a joiner transformation?

937

---

What is domain in terms of informatica?

952

---

Explain lookup transformation source types in informatica

1039

---

What are the features of complex mapping?

1095

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2077

---

Write the different tools in the workflow manager?

993

---

what is Active lock explain

2726

---

What is joiner transformation in informatica?

992

---

Explain what are the different types of transformation available in informatica.

1038

---

What does command task mean?

1062

---