Suppose I am loaded with questions as I am an experienced etl coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of non empty so that I dont see records that are blank.?

0 Answers  

---

What is a materialized view log?

0 Answers  

---

when should one create lookup transformation ?

2 Answers  

---

What is partitioning? Explain different types of partitioning?

0 Answers  

---

what are the facilities provided by data warehouse to analytical users?

0 Answers  

---

What is a staging area? What is the purpose of a staging area?

0 Answers  

---

how do u decide whether u need to do aggregations at database level or at Informatica level?

1 Answers   QualTech,

---

What is grain of fact?

0 Answers  

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  

---

What is initial load and what is full load?

0 Answers  

---

Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com

1 Answers  

---

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  

---