Answer Posted / kamleshmishra291

After SQ Take Aggr group by empid and create a variable port Rows_count=count(1)
Take a router after aggr and create two groups one for uniqe and one for duplicate
in uniqe condition = Rows_count=1
duplicate group condition= Rows_count>1
connect unique group to tgt1
connect duplicate group to java transformation---
add following codes
for (int i=0;i<count;i++)
{
o_empid=i_empid;
o_ename=i_ename;
o_loc=i_loc;
o_sal=i_sal;
generateRow();
}

connect java transformation to tgt2

Name the different lookup cache(s)?

1212

---

Different sorts of metadata that stores in the storage facility?

994

---

What is the way to execute pl/sql script using informatica mapping?

1581

---

What are the designer tools for creating transformations?

1099

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2039

---

What are the reusable transformations?

1142

---

Reusable transformation and shortcut differences

1821

---

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

972

---

Target increases every day even though no new record was inserted

1561

---

Explain lookup transformation source types in informatica

1079

---

What is the need of an ETL tool?

1070

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1910

---

How can we use mapping variables in informatica? Where do we use them?

1166

---

can anyone explain me about retail domain project in informatica?

7927

---

Explain joiner transformation in informatica

1107

---