Answer / sabyasachi

Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.

Slowly changing dimensions, types and where will you use them

0 Answers  

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

How to do Integration testing in Informatica?

5 Answers   Intelligroup,

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

---