Can u please describe the different types of traps with eg.
Thanks
Answers were Sorted based on User's Feedback
Answer / the_xxx
There are two main types of connection traps:
1. fan traps
2. chasm traps
Fan traps
A fan trap occurs when a model represents a relationship
between entity types, but the pathway between certain entity
occurrences is ambiguous. It occurs when 1:m relationships
fan out from a single entity.
Missing ALT text
Figure : Fan Trap
A single site contains many departments and employs many
staff. However, which staff work in a particular department?
The fan trap is resolved by restructuring the original ER
model to represent the correct association.
Missing ALT text
Figure : Resolved Fan Trap
Chasm traps
A chasm trap occurs when a model suggests the existence of a
relationship between entity types, but the pathway does not
exist between certain entity occurrences.
It occurs where there is a relationship with partial
participation, which forms part of the pathway between
entities that are related.
Missing ALT text
Figure : Chasm Trap
* A single branch is allocated many staff who oversee
the management of properties for rent. Not all staff oversee
property and not all property is managed by a member of staff.
* What properties are available at a branch?
* The partial participation of Staff and Property in the
oversees relation means that some properties cannot be
associated with a branch office through a member of staff.
* We need to add the missing relationship which is
called `has' between the Branch and the Property entities.
* You need to therefore be careful when you remove
relationships which you consider to be redundant.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / divakar
There will be traps w.r.t query joins in FM. They are when
1. there is infinite relation existing between query
subjects like A->B->C->A
2. there is ambiguous relationship(No proper relationship)
Then there will be traps while running the query or w.r.t.
data.
Is This Answer Correct ? | 1 Yes | 0 No |
-----------Diff b/w OLAP and RDBMS?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What are products of cognos?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
difference between stored procedure and function?
actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?
What are the batches and it’s details?
Use of Text Source Variable in Report Studio?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What you mean by drill across?