Answer Posted / terry derham

Hi, can you also email the Informatica 8 information
relevant to Informatica 8 certification to me please?
terryd@oakton.com.au

Many thanks

State the differences between shortcut and reusable transformation

1118

---

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

999

---

What is grain of fact?

1026

---

What is meant by incremental load?

1160

---

what is data modeling?

1951

---

What are the different Lookup methods used in Informatica?

963

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2940

---

What is a mapping, session, worklet, workflow, mapplet?

1055

---

What is data modeling and data mining?

1023

---

please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance

2532

---

What is a lookup table in etl?

1236

---

what are the session parameters? How do u set them?

2094

---

Explain different types of partitioning?

1097

---

How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

2315

---

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2684

---