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

What are ETL Tools?

1119

---

How can we handle two sessions in informatica?

1033

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

---

How to extract sap data using informatica? What is abap? What are idocs?

1182

---

 Informatica Checkpoints

3332

---

What is the need of etl tools?

1120

---

According to his methodology what all you need before you build a datawarehouse

1759

---

Write the unconnected lookup syntax and how to return more than one column.

1110

---

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

1107

---

Explain the types of transformations?

1069

---

What is the Process to creating lookup transformation in informatica

1046

---

What is the cumulative sum and moving sum?

1186

---

Target increases every day even though no new record was inserted

1581

---

How can informatica be used for an organization?

1220

---

What are the informatica performance improvement tips

1094

---