Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

0 Answers  

---

What is the main difference between inmon and kimball philosophies of data warehousing?

0 Answers  

---

Explain what are the different methods of loading dimension tables?

0 Answers  

---

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

1 Answers   ABC,

---

What is a full backup?

0 Answers  

---

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

0 Answers  

---

Explain what is a staging area? Do we need it? What is the purpose of a staging area?

0 Answers  

---

In a star schema, are foreign key constraints between facts and dimensions neccessary?

0 Answers  

---

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

0 Answers  

---

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

0 Answers  

---

Explain how to export mappings to the production environment?

0 Answers  

---

What is Data purging?

8 Answers   TCS,

---