Interested to Buy Any Domain ? << Click Here >> for more details...
What are the traps ? What are the disadvantages of traps?
- 5 Answers
- 10036 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prakash123
Traps are join problems in Universe.The disadvantage of
traps are
1)In accurate date
2)cartesian product
Cheers
Prakash
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / praveen
Traps will occur because of cardinality.
Traps are of 2 types:
1) Chasm trap
2) Fan trap
Disadvantages of traps are
More number of results
Cartesian Product
We can resolve traps by using both Alias and Contexts.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / babu
Traps are recives inacuurate data in report level, we need
to trace it by Manually.
A.Fan trap
B.Chasam TRap
A .If tables are joined as A(1:M)-->B(1:M)-->C we will get
more results than expected. through Alaias or Agg Awarenees
we can resolve. this is called as Fan trap.
tables B holds the Aggarigated values from A table then
only we will encounter fan trap is occured.
B. if tables are joined like B(m:1)<--A-->(1:m)C. This
CHASM trap can be resolved by executing separate query for
each measure and then merging the results.Use detect
context automatic tool to detect possible context in
universe and use them in order to avoid CHASM traps.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kodandapani.ancha
Traps nothing but joint path problems in the
universe..disadvantage is results is ambiquity..to resolve
| Is This Answer Correct ? | 0 Yes | 1 No |
Who launches the supervisor product in Business Objects for first time?
How we drill up week to month?
How to resolve the partial result error in the report
What is the difference between Thin client & thick client?
What is slicing and dicing in business objects?
I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
Explain the difference between detect alias and detect context?
10.why we are going to data warehouse?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
Pls say any one... how will u create a report using oracle stored procedure? could u pls send me the step.....
Teradata 
