why dimenstion tables are denormalized in nature ?

3 Answers  

---

What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?

0 Answers   CTS, Wipro,

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

What is aggregate awareness?

1 Answers  

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---

---

What is a sequence generator transformation?

0 Answers  

---

What is olap (on-line analytical processing?

0 Answers  

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

how to work with mapplet designer in informatica?

7 Answers  

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

What is the function of look up transformation?

0 Answers  

---

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

---