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 the main issues while working with flat files as source and as targets ?

1216

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

1112

---

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

1212

---

What is deployment group?

1296

---

permutations of mapplet

2548

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1141

---

Define filter transformation?

1147

---

What is a surrogate key?

1153

---

What are the different transaction levels available in transaction control transformation?

1273

---

What are some examples of informatica etl programs?

984

---

What is the need of an ETL tool?

1157

---

What is flashback table ? Advance thanks

1998

---

Reusable transformation and shortcut differences

1880

---

How to load a Dimension ? and how to load a fact table?

1461

---

Enlist some properties of sessions.

1135

---