Explain What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Submitted by: AdministratorCartesian product is getting incorrect results.
for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.
ex:-
we have customer,orders,loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.
Submitted by: Administrator
for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.
ex:-
we have customer,orders,loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.
Submitted by: Administrator
Read Online Business Objects Job Interview Questions And Answers
Top Business Objects Questions
☺ | What is difference between Webi and Infoview? |
☺ | What is the difference between BoXIR2 and BOXIR3? |
☺ | Explain What is the difference between slice and dice and cross tab report? |
☺ | Explain Are Data mart and DWH normalized or denormalized? Do both of them exist in |
☺ | 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)? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |