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.

what is cognos architechure

4 Answers   Cap Gemini,

---

New coloums are added in database, then how you know in report level

0 Answers   Accenture,

---

how can i test the reports in cognos

1 Answers   IBM,

---

In a Single page we are having 3 list. While running each has to populated in separate page?

2 Answers   TCS,

---

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

---

Cleared COG-112 with 100% score today. What next certification should i go for?

0 Answers   IBM,

---

How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,

---

Can you explain new content durability?

0 Answers  

---

Column level security in report

4 Answers  

---

Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!

0 Answers   Wipro,

---

Once reports are delivered to client, how will they inform back? If they are experiencing any problem in the reports.

2 Answers  

---

can you apply grouping on crosstab?

1 Answers   CTS,

---