Series: Subject: Topic:
Question: 127 of 200

What is fan trap? How do you find out? How do you resolve that loop?
What is chasm trap? How do you find out? How do you resolve that loop?
How you provide security for reports?
Whenever you open a report it refresh automatically? How do set this.
Can you use different database for different universes?
What are the types of universes?

Asked by: vasanth96 | Member Since Jul-2007 | Asked on: Jul 9th, 2007

View all questions by vasanth96

Showing Answers 1 - 3 of 3 Answers

Yes, we can use different databases for different universes. BOXI R2 supports all RDBMS databases like Oracle, MSSQL 200/2005, DB2, MS Access..etc.Regards,Ravi Kumar

Login to rate this answer.

Answered On : Mar 19th, 2009

View all answers by johnftamburo

A fan trap is a many-to-many relationship between two fact tables, bridged by a dimension.

Login to rate this answer.

Answered On : May 9th, 2012

Fan trap: one of the schema-tables in your physical realization via an rdbms has a 1:many relationship between two slave-tables but there is no path between the two slave tables! So we are clueless about the fk between them and the cardinality of the join is undefined leaving you powerless to query the data between the two slave tables

Chasm trap is a many-to-many join between two tables and requires a bridge table to resolve the context of the join.example:one product has one or many customer-orders and one customer has zero or many order-cancellations& returns

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



twitter fb Linkedin GPlus RSS


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.