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 

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2094

---

How to create a non-reusable instance of reusable transformations?

1081

---

What is Cognos script editor?

4187

---

What is source qualifier transformation in informatica?

965

---

How big was your fact table

1762

---

Explain about cumulative Sum or moving sum?

996

---

Please let me know how to make encryption and decryption with example?

1872

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2206

---

What is exclusive and normal mode for repository services?

1087

---

What is domain and gateway node?

1132

---

What is standalone command task?

1285

---

What is the difference between stop and abort in informatica

1058

---

What could be the possible resons of locks by user?

1063

---

Briefly define reusable transformation?

1101

---

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,

7139

---