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 

Write the prerequisite tasks to achieve the session partition?

1170

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1716

---

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

1213

---

Write the program through which the records can be updated?

1012

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1135

---

what is the difference between informatica6.1 and infomatica7.1

2287

---

Where can we find the throughput option in informatica?

1072

---

Explain lookup transformation source types in informatica

1108

---

What is workflow manager?

1059

---

Tell me about MD5 functions in informatica

935

---

What is powercenter on grid?

1190

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2017

---

What is the different lookup cache(s)?

1095

---

What is a stored procedure transformation?

1064

---

Explain the use of aggregator cache file?

1263

---