What is is the Guidelines to Build Universe with Better Performance? R Performance tuning Issues of Universes?
Submitted by: AdministratorGuidelines are provided in the Universe guide:
Here is the Summary:
1) Modify the array fetch size in SBO file
2) Assign table weights and change the default order of the tables in a query by changing parameter in PRM file
3) Use shorcut joins to avoid unnecessary tables that may come in Query
4) Use aggregated tables
Submitted by: Administrator
Here is the Summary:
1) Modify the array fetch size in SBO file
2) Assign table weights and change the default order of the tables in a query by changing parameter in PRM file
3) Use shorcut joins to avoid unnecessary tables that may come in Query
4) Use aggregated tables
Submitted by: Administrator
Read Online BO Designer Job Interview Questions And Answers
Top BO Designer Questions
☺ | What is index awareness in universe? |
☺ | Could any one explain me how to create cascading prompts? |
☺ | What are steps we have to follow in designing the userfriendly Universe? |
☺ | How do we design a universe? |
☺ | How to create Universe using Flat file in BO6.0? |
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. |