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.

suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  

---

What are the advantages and disadvantages of using Transformer cube?

1 Answers   TCS,

---

How do we implement Check Box Prompt in COgnos Report Studio?

2 Answers  

---

how to create calculate column in report studio

4 Answers  

---

What is stitched Query?

5 Answers  

---

What is the difference between the content store and content manager?

0 Answers  

---

What is a Cube?

0 Answers  

---

What are variable report studio?

1 Answers   HCL,

---

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,

---

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

0 Answers  

---

Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?

2 Answers   Satyam,

---

-----------Types of Fact Tables?

6 Answers   Bank Of America, CTS,

---