ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Informatica
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (178)
 Business Objects interview questions  Business Objects Interview Questions (750)
 Cognos interview questions  Cognos Interview Questions (836)
 Informatica interview questions  Informatica Interview Questions (1617)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (168)
 Data Stage interview questions  Data Stage Interview Questions (562)
 SAS interview questions  SAS Interview Questions (549)
 Micro Strategy interview questions  Micro Strategy Interview Questions (35)
 ETL interview questions  ETL Interview Questions (193)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (214)
Question
What are the different types of schemas?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What are the different types of schemas?
Answer
# 1
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
 
Is This Answer Correct ?    67 Yes 25 No
Ande
 
  Re: What are the different types of schemas?
Answer
# 2
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.
 
Is This Answer Correct ?    32 Yes 39 No
Vignesh Muralidharan
 
 
 
  Re: What are the different types of schemas?
Answer
# 3
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
 
Is This Answer Correct ?    21 Yes 22 No
Chowdary
 
  Re: What are the different types of schemas?
Answer
# 4
star scema an snowflake schema 
Is This Answer Correct ?    5 Yes 23 No
Priya
 
  Re: What are the different types of schemas?
Answer
# 5
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
 
Is This Answer Correct ?    23 Yes 19 No
Giri
 
  Re: What are the different types of schemas?
Answer
# 6
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.
 
Is This Answer Correct ?    34 Yes 10 No
Kalyan
 
  Re: What are the different types of schemas?
Answer
# 7
schems are two types one is star schema and another one is
snow flake schema
 
Is This Answer Correct ?    3 Yes 8 No
Ramesh
 
  Re: What are the different types of schemas?
Answer
# 8
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.
 
Is This Answer Correct ?    16 Yes 6 No
Mallikarjun
 
  Re: What are the different types of schemas?
Answer
# 9
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.
 
Is This Answer Correct ?    6 Yes 1 No
Thirumalai
 

 
 
 
Other Informatica Interview Questions
 
  Question Asked @ Answers
 
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION   4
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..? Zensar 2
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?   2
what is difference between dimention table and fact table?   1
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)   1
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable) TCS 4
who to split dimentions into sub dimention Wipro 3
Why the UNION TRANSFERMATION is an Active TRANSFERMATION Emphasis 6
what are the difference between Informatica 7.1 and 8.1?   6
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table? Wipro 1
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis? Polaris 4
where to select code page option? TCS 2
 
For more Informatica Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com