Answer / karthik

You can increase the loading of query faster in following ways:

Query Optimization (Reducing the complexity in query).
Buffer cache increasing
Using Tier 0 (Flash storage) to increase IOPS.

What is meant by target load plan?

0 Answers  

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

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,

---

What is an active transformation?

0 Answers   Informatica,

---

What is hash partition?

2 Answers  

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

What is the benefit of partitioning a session?

0 Answers  

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

in static and dynamic which one is better

2 Answers  

---