Answer Posted / harish

olap tools or reporting tools can be connected to only ONE
database.If we need a report of data from more than one
database like oracle,SQL Server and DB@ then all the data
is put into a datawarehouse database and then the olap tool
can be connected to this datawarehouse database and the
necesarry reports can be generated.

As far as i know this could be a good answer.

Hope this answer helps.
Experts please correct me if i am wrong.
Regards
Harish.

Tell me what is full load & incremental or refresh load?

950

---

How to stop a batch?

982

---

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2126

---

What is the difference between agglomerative and divisive hierarchical clustering?

1184

---

How to create diff. Types of templates?

1047

---

Explain what is data validation strategies for data mart validation after loading process?

1028

---

Explain vldb?

1033

---

Explain what does level of granularity of a fact table signify?

956

---

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

962

---

What are the different types of datawarehosuing?

991

---

What are the different types of segments?

991

---

How do you create surrogate key using ab initio?

996

---

How to generate the cubes in framework manager?

1040

---

Explain what is the difference between powerplay transformer and power play reports?

1157

---

I have two universes created by two difference database can we join them in designer & report level? How

982

---