Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

How to delete duplicate records in a flat file source?

2 Answers  

---

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.

4 Answers   JPMorgan Chase,

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?

1 Answers  

---

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

---

Differentiate between a database and data warehouse?

0 Answers  

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..

3 Answers   CTS, HCL, Infosys, TCS,

---

What is mapplet and a reusable transformation?

2 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

Explain the informatica workflow?

0 Answers  

---