what is query optimizer? what are different types of optimizer s supported by oracle ?

1 Answers   ABC,

---

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,

---

What are components of reportnet?

0 Answers  

---

Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?

0 Answers  

---

When should you use a STAR and when a SNOW-FLAKE schema?

6 Answers   Accenture,

---

What is a ETL/ How does Oracle support the ETL process?

1 Answers  

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?

0 Answers  

---

Why null values are mapped as 0 in fact tables?

0 Answers  

---

How do you setup Lo-cockpit?

0 Answers  

---

what is the difference between aggregate table and fact table ? how do you load these two tables ?

12 Answers   Target,

---

what is indexing ? what are different types of indexes supported by oracle ?

2 Answers  

---

What do you mean by static and local variable?

0 Answers  

---