Answer / ande

two types of schemas r there: Star schema and snow flake
Schema: in Snow flake schema normalozation is promoted
where as in star schema denormalization is promoted. incase
of snowflake schema DB size will be saved but no of joins
will be increased and poor performance compare with star
schema
regards,
ande

Answer / kalyan

3types of schems:
Star Schema (As above)
Snow Flake Schema (As above)
Galaxy or Integrated or Fact Constellation Schema ( By
which, a dimensional table is shared by one or more Fact
tables )

Good Luck.

Answer / mallikarjun

There are 3 types of Schemas,
1.Star Schema
2.Snowflake Schema
3.Galaxy/Integrated/Hybride/Consalation Schemas
1)Star Schema-It is defined as the fact table is centrally located,surrounded by dimension tables is called star schema.In that dimension tables are denormalized and fact table is normalized.(or)Star schema is defind as two or more fact and two or more dimension tables that are related to foreigh keys.
2)Snowflake Schema-It is defind as the Denormalized Dimensions tables are can be splited into two or more normalized dimensions is called snowflake schema.In that both dimensions and fact tables are normalized.
3)Hybride Schema-It is defind as a dimension table is shared by two or more fact tables.

Answer / thirumalai

There are 3 types of Schemas :
1. Star Schema -The star schema architecture is the
simplest data warehouse schema. It is called a star schema
because the diagram resembles a star, with points radiating
from a center. The center of the star consists of fact
table and the points of the star are the dimension tables.
Usually the fact tables in a star schema are in third
normal form(3NF) whereas dimensional tables are de-
normalized. Despite the fact that the star schema is the
simplest architecture

2. Snow Flake Schema - The snowflake schema architecture is
a more complex variation of the star schema used in a data
warehouse, because the tables which describe the dimensions
are normalized

3. Fact Constallation Schema : For each star schema it is
possible to construct fact constellation schema(for example
by splitting the original star schema into more star
schemes each of them describes facts on another level of
dimension hierarchies). The fact constellation architecture
contains multiple fact tables that share many dimension
tables.

Answer / giri

Schema is structure of information

1.STAR SCHEMA
-------------
Centralized Fact table connect the one or more denormalized data

2.SNOW FLAKE SCHEMA
-------------------

Centralized Fact table connect the one or more normalized data

3.STAR FLAKE SCHEMA
-------------------

One or more centralized fact table connect the single denormolized data

Answer / gopi

star schema
snow flae schema
hybrid schema
multistar schema

Answer / kick

Very nice page I must say.

Mainly Data warehouse has three type of schemas available.

1. Star Schema

2. Snow Flake Schema

3. Fact Constellation Schema or Galaxy Schema

It was really hard time for me to get to know exactly how this all schema works and what is the main differences between these schema.

I searched a lot on web and got one detailed answer in below link. May be this can also help you guys to understand.

http://www.aajsearch.com/142/what-are-the-different-schema-in-data-warehousing

Answer / chowdary

There are two types of shemas
1 star schema , 2 snowflake schema
star schema : a fact table related to tha dimension tables
like in the fact table it contain refernce keys of
dimension tables. and dimension tables dont related to the
other parent table . it view like a star so its call star
schema. if this use to avoid more joins
snowflake schema: a dimenion table with related to the it
hirerchi tables. like time dimensin table year dimension
table, month month dimension table, week dimension table
it view like snowflake

Answer / ramesh

schems are two types one is star schema and another one is
snow flake schema

Answer / vignesh muralidharan

three types of schemas are availble.Star schema,star flake
schema & snow flake schema.

Star schema:It is highly denormalised,so we can retrieve
the data very fast.

Star flake schema:Only one dimension contain one level of
hierachy key.

Snow flake schema:It is highly normalised,so retrievel of
data is slow.

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

Where do we use mapping variables in informatica?

0 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

What is joiner transformation?

0 Answers  

Define Pmrep command?

0 Answers  

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

What is joiner cache?

2 Answers   TCS,

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

What are the databases that informatica can connect to windows?

0 Answers  

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,