Interested to Buy Any Domain ? << Click Here >> for more details...
what is fantrap and chasmtrap ?
- 5 Answers
- 16586 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 |
Report have 10000 records,how to restrict the end user to 1000 Records?
Explain the difference between detect alias and detect context?
How to generate the report from excel sheet?
in sap bi we have wad, then why we go for sap bo
How toconnect one to one report?
I have a report with n number of records. i want to take alternative rows as a red in color. How to make it?
What is the dense rank?
Explain about alerts in bos, under what situation we need to use alerts?
How to change the order of prompts in universe?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the link option in the reporting Environment?
What is a category?
Teradata 
