Answer / nagaraju bhatraju

parallel queries to optimize query execution and index
operations for computers that have more than one
microprocessor (CPU). Because SQL Server can perform a
query or index operation in parallel by using several
operating system threads, the operation can be completed
quickly and efficiently.

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

Differentiate between router and filter transformation?

0 Answers  

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

explain abt union t/r?

1 Answers   IBM,

---

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

Explain factlessfact table with scenario

1 Answers   HCL,

---

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

---

Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---

what is the size of u r source(like file or table)?

0 Answers   HP,

---

Which will beter perform IIf or decode?

3 Answers   TCS,

---