Answer / gokulakrishnan

Actually FAN TRAP is a problem that occurs in Universe
Level. Loop occurs while we design the universe.

Two Types of Loop Problem:

1) FANTRAP PROBLEM solved by ALIAS METHOD:

Definition: Two One-to-many table link eachother is in turn
linked another one-to-many table.

2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:

Definition: Two Many-to-one table converges on one single
lookup table.

Loop can be detected while INTEGRITY CHECK is done. An
option is there as "Check for LOOPS" available. By "Detect
Loop" we can choose what to be applied for solving the loop.

Answer / vams_gk

fantrap is the one of the concept to solve join
problems.the table contains 1:m relationship paralally it
is fan trap..it is coming upby situvation

What would you consider as your biggest achievement and why?

0 Answers  

---

what are the roles and responsibilities of BO Administrator ?

1 Answers   OCS Infotech, TCS, Wipro,

---

What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?

2 Answers   CTS,

---

WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

How to sheduling the report ? What is the need of it?

2 Answers   Infotech,

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  

---

what is casual dimension?

1 Answers   CA,

---

what are slowly changing dimensions, confirm dimensions?

1 Answers   Wipro,

---

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---

can u create report to connect oracle and sqlserver at a time?

2 Answers   Zensar,

---

What are the general issues in migration process?

3 Answers   Deloitte,

---