Example of how the fantraps and chasm traps works?
- 1 Answers
- 14032 Views
- IBM, I also Faced
- E-Mail Answers
Answer / abdul
Chasm trap and Fan Traps are the loops which will occur
while ditecting loops.
Examples of these are:
Chasm Trap:
Orders
Customer <
Sales
When one dimention is having one to many relations with two
diffrent facts then this loop will occur. To resolve this
loop we have to use Context to chose the right path for the
reports to avoid multiple SQL statements.
Fan Tap:
Customer -> orders -> orderlines.
When one customer dimention is having one to many relation
with orders and then again orders is having one to many to
relation with orderlines then the loop will occure. To
resolve this we have to use aliase. Name the second table
oreders with some other alias name then link with third
table. Ensure to remove the link between 2nd and 3rd tables.
Hope this will answer your question.
Thanks,
Abdul
| Is This Answer Correct ? | 15 Yes | 10 No |
Explain what are the measure objects?
what is a filter?
What is the aggrigate navigation ? can anybody explain me with some practical example?
if there are 2 hierarchies 1 is a-b-c and another one is a- c which hierarchy b.o takes while we use drill mode
what will be the contents for a functional requirements specifications
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what types of challenges we are faced in creating web i reports .can you please explain with some examples.
How to make alternative rows red and green in WebI Report?
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
what are cascading prompts explain with steps
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
Explain what is the difference between slice and dice and cross tab report?
Teradata 
