Answer Posted / reddeppa reddy

select departmentname,max(sal) from department table group
by deptid

What is Star Schema?

1064

---

Describe a data warehouse.

915

---

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

903

---

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?

1015

---

Explain differences between star and snowflake schemas?

1050

---

What is a full backup?

907

---

How to handle multi value dimensions?

2222

---

Explain what is analytical or analytic mean?

959

---

After we create a scd table, can we use that particular dimension as a dimension table for star schema?

933

---

What is the working process for application.cfm?

982

---

Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

953

---

What is the differences between star and snowflake schemas?

985

---

What is the difference between metadata and data dictionary?

1061

---

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 meetthe condition.

1031

---

Explain what are the advantages of query studio compared to report studio?

968

---