1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

comonly how meny mappings r there in Banking projects?

1 Answers  

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

explain abt joiner t/r?

1 Answers   IBM,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,

---

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers   CTS, TCS,

---

how we do performence tuning in informatica

3 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---