Interested to Buy Any Domain ? << Click Here >> for more details...
what is fantrap and chasmtrap ?
- 5 Answers
- 16575 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santhosh
Fantrap means one-to-many joins of the tables it is
detected by visval analysis. By using fantrap problem is
many rows than expected. Through aliases,context and check
mutiple sql statements for each measures option we can
solve this problem.
chasm trap means two or more many to one joins converge on
to a single lookup table
| Is This Answer Correct ? | 11 Yes | 0 No |
Chasam Trap:
chasm trap means many-to-one and one-to-many join relation
converge on to a single lookup table, because of this we
get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times context,
some times shortcut join and check mutiple context for each
measures option.
Fan Trap:
Fantrap means one-to-many and one-to-many join relation of
the tables it is detected by visval analysis, because of
this we get incorrect results i.e., cartision product,
We will resolved by using some times alias, some times
shortcut join and check mutiple sql statements for each
measures option.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / shiva
these two are the loop problems
fantrap-fanning out of one to many leads to one to many
relation ships
chasamtrap-converging two fact tables into single lookup
table
fantrap can be solved by alias
chasamtrap can be solved by context
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nmr
fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nmr
fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is aggregate table and aggregate fact table ... Any examples of both?
How many universe dfi you create if you have 2 years of experience in BO
How do u get requirement from the client? in what format?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
how to create a derived table in designer? i need steps regarding derived table
Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example
4.what is aggregate awareness ? how do we use ? where do we use ?
What is the difference between master-detail and Breaks?
Explain in detail about type 1?
How to link two different universes ?
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?
How many universes will run maximum in single project
Teradata 
