Interested to Buy Any Domain ? << Click Here >> for more details...
what is fantrap and chasmtrap ?
- 5 Answers
- 16328 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 |
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
What is package in BO
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
how do you share the universe ?
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance
draw the architecture of bo
How can we use multiple data providers in a single report in business objects?
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.
What is DSS?? (Defination of DSS)
What is Designer?
What are the Errors in BO Pls Explain with Examples
2 Answers iFlex, Tech Mahindra,
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Teradata 
