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.

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.

There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers   BitWise,

---

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

1 Answers   CTS,

---

What are the different ways of adding data in Transformer?

3 Answers   Cognos, IBM,

---

first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.

1 Answers  

---

what is differences between the group span and levelspan

1 Answers  

---

WHAT STEPS SHOULD BE TAKEN BY A REPORT DEVELOPER TO INTERACT WITH THE CLIENT SERVER?

1 Answers  

---

what is cognos architechure

4 Answers   Cap Gemini,

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---

What is the use of report studio?

0 Answers  

---

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

---

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error

0 Answers   IBM,

---

what is model and how to create model and how to test model?

8 Answers   IBM,

---