Answer Posted / lokesh y g

using dynamic lookup we can do it......

have u done any performance tuning? how u ll do?

2299

---

Clarify the utilization of aggregator cache record?

1001

---

Where are the source flat files kept before running the session?

1078

---

What are the uses of etl tools?

1128

---

What is the status code in stored procedure transformation?

1182

---

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

2012

---

Explain direct and indirect flat file loading (source file type) - informatica

1318

---

How can you validate all mappings in the repository simultaneously?

1371

---

What are mapplets?

1271

---

Can we create two repositories on same database instance in oracle?

1092

---

What are batches?

1100

---

COM components can be used in Informatica

2390

---

What is flashback table ? Advance thanks

1934

---

What are the data movement modes in informatica?

1153

---

Can u generate reports in Informatica?

1087

---