Answer Posted / skolla80

Can you please email me a copy of informatica Certification
Exam dumps to srini.kolla@gmx.com

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

2119

---

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.?

996

---

What are cubes and olap cubes?

1044

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

2082

---

Explain etl?

1031

---

can cubes contain measures ?

2072

---

Explain do we need an etl tool?

1074

---

what are the data modeling tools you have used?(polaris)

2046

---

Mention few test cases and explain them?

980

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2603

---

how to connect to a flatfile through ftp in informatica

14384

---

what are the types in error loging?

2192

---

explain the methodology of Data Warehousing?(Polaries)

2365

---

where are the log files generally stored.Can you change the path of the file.what can the path be?

2493

---

what is the difference between cubes and package in cognos

4999

---