Answer Posted / kishore

i think in real time minimum 3 and maximum 5 repositories we create

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

2062

---

Could any one explain me how to create cascading prompts?

981

---

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

915

---

What does level of granularity of a fact table signify?

1035

---

Why should we use data ware housing and how can you extract data for analysis with example?

932

---

Explain difference between snow flake and star schema.

958

---

What are the steps involved in designing a fact table?

838

---

What is the difference between aggregate table and materialized view?

1027

---

what are the others of "bad files" and "discard files" when using sql*loader?

2057

---

What is surrogate key? Explain with examples.

1054

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

976

---

What is application.cfm?

998

---

What function should we use to display the value entered or selected by a user in response to a prompt?

920

---

What is operational data store (ods)?

953

---

Explain why fact table is in normal form?

916

---