Answer / arkchowdary

Hi,
There are 4 types of schemas are there.

Star Schema,
Snowflake Schema,
Starflake Schema,

Galaxy Schema.

Satar Schema---------------- In a starshema a central
facttable connects a number of individual dimension tables
this is called as a starschema.
------------ It contains lessjoins so perfomance will be
increase.
------------ Starschema contains denormalized data.

Snowflake Schema------------- One dimension table split into
more than one dimension this is known as snowflakeschema.

---------------- Snowflake contains normalized data. There
are more joins in snowflake schema. so the performance is
degrade.

Galaxy Schema-------- Galaxyschema is known as a
Factconstollation schema. It requires number of facttables
and Dimension tables this is known as a Galaxyschema.

I hope it willbe helpful.

Answer / krishna

Schema is nothing but logical structure of data.
there of four types
1.star schema
2.snowflake schema
3.star flake schema
4.galaxy schema

Answer / swan

There are 2 types of schemas
1)star schema
2)snowflake schema

star schema is amiddle of the fact table it connects to the
no.of individual dimention tables.It containd de-normalized
data

snowflake schema is is a set of tables comprised of a
single, central fact table surrounded by normalized
dimension hierarchies. Each dimension level is represented
in a table. Snowflake schema implements dimensional data
structures with fully normalized dimensions. Star schemas
are an alternative to snowflake schema

Answer / satya

There are two types of schemas are there
1) Star schema
2) snow flake schema

Define olap designer?

0 Answers  

---

What is the difference between Standard and Metrics folder?

0 Answers  

---

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

0 Answers   IBM,

---

Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

0 Answers   IBM,

---

-------------Diff b/w Union and Unionall?

3 Answers   Cap Gemini,

---

How can we change any header or footer for a group of reports

1 Answers   Satyam, Tech Mahindra,

---

I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows

2 Answers  

---

what is report view?

4 Answers   Cap Gemini,

---

What is the report studio?

0 Answers  

---

What is conditional Formatting?

2 Answers   HCL,

---

what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)

1 Answers   HCL, Syntel,

---

What do you mean by drill through report?

0 Answers  

---