Answer Posted / mohan

Here is the minor modification on Answer #6 posted by me,
SQ-->Sorter-->Expression-->Router-->Targets

Sorter Transformation: Sort by key column(EMP_ID)
Expression Transformation:
V_Match(variable port) =IIF(EMPNO=V_OLD_EMPNO,1,0)
V_OLD_EMPNO(Variable)= EMP_ID
O_EMPNO(output)= V_MATCH

Router Transformation:
create two groups under groups tab,
Original : O_EMPNO=0
Duplicates: o_EMPNO=1 

What are ETL Tools?

1043

---

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2317

---

How many ways a relational source definition can be updated and what are they?

956

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8130

---

What is informatica powercenter repository?

1144

---

What are the performance considerations when working with aggregator transformation?

1097

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7117

---

What are the various types of transformation?

1097

---

Please let me know how to make Data masking in informatica..

1665

---

Briefly define a session task?

1057

---

what is song in infrmatica...?

2163

---

What is olap (on-line analytical processing?

1009

---

Which version configuration tool used in ur project?

3184

---

In how many ways we can create ports?

1067

---

How to delete duplicate row using informatica?

984

---