in which situations do u go for snowflake schema ?

2 Answers   TCS,

---

What is rank index in rank transformation?

0 Answers  

---

What is IQD file?

1 Answers  

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

What are the phases in SDLC?

3 Answers  

---

---

we r using aggregator with out using groupby?

7 Answers   HSBC, Principal Finance,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

---

when do we use static cache and when do we use dynamic cache in lookup transformation? with example.

1 Answers  

---

disable caching in a lookup transformation?

1 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---