why dimenstion tables are denormalized in nature ?

3 Answers  

---

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

5 Answers   Patni,

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers   IBM, TCS,

---

expain about the tune parameters?

0 Answers   TCS,

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

---

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

5 Answers   iGate,

---

What are pre and post-session shell commands?

0 Answers  

---