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 the use of structures?how many nodes can u create in a structure?

0 Answers  

---

How can write SQL Overwrite to get Daynamic rows from the source in SQ transformation!(Any Example)

1 Answers  

---

how would u estimate the size of Lookup transform data and index cache?

0 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

working of line item dimension......pls,tell overall flow

1 Answers  

---

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

1 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers  

---

What are cubes and olap cubes?

0 Answers  

---

What is fact? What are the types of facts?

0 Answers  

---

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

0 Answers  

---

What is tracing level?

0 Answers  

---