GeekInterview.com
Series: Subject: Topic:
Question: 183 of 200

How Many different schema's or DW Models can be used in Siebel Analytics. I know Only STAR and SNOW FLAKE. Any other model that can be used??

Asked by: Interview Candidate | Asked on: Jun 23rd, 2006
Showing Answers 1 - 3 of 3 Answers
lakshmi

Answered On : Apr 30th, 2007

Integrated schema design is also used to define an integrated schema design we have to define the following concepts1)fact constellation2)fact less fact table3)conformed dimension1:  A fact constellation is the process of joining two or more fact tables2: A fact table with out any facts is known as fact less fact table3:A dimension which is re useful and fixed is known as conformed dimension                 orA dimension which is shared with multiple fact tables known as conformed dimension

Yes  1 User has rated as useful.
  
Login to rate this answer.
uma

Answered On : May 17th, 2007

There are 3 types of schemasstar schemasnowflake schemaand galaxy schemabyuma

  
Login to rate this answer.
tisha24

Answered On : Dec 18th, 2008

View all answers by tisha24

One more is there, known as "GALAXY SCHEMA"

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Question Categories

Abinitio Interview Questions

Analysis services Interview Questions

Data Warehousing Basics

BO Designer Interview Questions

Business Intelligence Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Data Warehousing Concepts

BO Data Integration

DataStage Interview Questions

ETL Interview Questions

Hyperion Interview Questions

Impromptu Interview Questions

Informatica Interview Questions

MicroStrategy Interview Questions

Reportnet Interview Questions

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.