Answer / priyaraj

Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.

Post SQL means IS runs SQL commands against target database
after it writes to the target.

what is the process of target load planing?

2 Answers   IBM,

---

what is pre and post sql and what is diff between source presql and target pre sql

1 Answers   HCL, IBM,

---

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

what is unique constraint error ?

2 Answers   TCS,

---

"Change cache" in Informatica ?

2 Answers  

---

What is the advantage of informatica?

0 Answers  

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

Enlist the differences between database and data warehouse.

0 Answers  

---

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---