every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

Explain what are the different versions of informatica?

0 Answers  

---

Explain sessions and how many types of sessions are there?

0 Answers  

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

---

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

what is the predefined port in dynamic lookup

2 Answers  

---

What is the difference b/w natural key and surrogate key

1 Answers  

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---