Answer Posted / srinivasan manoharan

Grain and Granularity mean the same. It reflects the level
of detail in data warehouse.

Explain what are the basic needs to join two sources in a source qualifier?

621

---

What is is a star schema?

668

---

How many project sources we can create in metadata?

646

---

Explain if a flat file cotains 1000 records how can I get first and last records only?

610

---

Explain what is ods (operation data source)?

637

---

---

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

1757

---

Which columns go to the fact table and which columns go the dimension table?

653

---

What is a core dimension?

704

---

What are the different types of segments?

625

---

What is data type of the surrogate key?

693

---

What is the differences between star and snowflake schemas?

625

---

How to stop a batch?

620

---

What is data stream and data adaopter. Is it same are different? Explain?

570

---

What are modeling tools available in the market?

662

---

How much data hold in one universe.

644

---