business objects-3

1. Installation:
2. Configuration:
3. BO:
4. Supervisor:
5. WeBI:
6. Performance:
7. General:

1. What type of joins results incremental results?
Loops, Chasm trap, fan trap, Serial many-to-many

2. What is fan trap and how do you detect it and resolve it?
Create alias and aggregate
Using multiple statements for each measure

3. How you resolve a loop? Which is best way / why? Example
4. Can we use both context and aliases together? Example
5. What are join paths that return too many rows?
Chasm and Fan traps
Chasm trap, occurs when many – to many relations are present






Create a context for each fact
Modify the SQL parameters for Universe, so we can generate separate queries for Dimensions and Detail objects
Break the Universe into multiple – one for each fact

6. How to implement @ Aggregate functions? And @ prompt functions?
7. How many models can we save in a Universe?
Enterprise and Workgroup
8. How many ways can we distribute a universe/
9. What is workgroup design?
Designer provides
10. What is an incremental exporting of Universe/
11. What is distributed repository? Its mechanism and purpose
12. Can we migrate Universe from one Domain to another? How
13. Can we migrate Linked Universe from one Domain to another? How
14. How can we Exchange of Universe and Documents between repositories.
Save as work group mode
15. What are Linked Universes? Approach for linked Universes
Kernel
Master
Component
16. What are the types of schemas supported by BO?
17. What is BO repository & what are Domains?
18. How many types of Installations are there?
Server Products
Desktop Products
19. How we do master setup installation?
20. How do u recognize that Repository is installed or not? Where the repository info is stored? What are the conventions?
Check for .key file
21. Where the BO key files can be located? can multiple keys can coexist?
22. What are the connectors and types?
Secured – stored in security domain of repository
Shared – stored in sdac.lsi or sdac.ssi
Personal – stored in psdac.lsi or pdac.ssi
23. Can we update the parametrers of personal connection?
No, Its static
24. What are strategies? What is external strategy? Where is it located?
STG section of .PRM files located in RDBMS folders
25. What is the Purpose of joins? What are types of joins supported in BO? What is shortcut join? What is outer join? Examples
Four
26. What is cardinality? How many cardinalities does a join possesses?
27. How to improve the response time of cardinality detection? Which parameter of .PRM file do we need to modify?
LIGHT_DETECT_CARDINALITY = YES
28. What is the purpose of checking integrity function serves?
Detects errors, loops, Contexts, Changes In db
29. How to determine whether a database has been changed?
Use integrity checker
30. Advantages of Linked Universes
Reduce development time
Reduce maintenance
Code reusability
Facilitates specialization
31. Why we go for Linked Universe?
Same RDBMS
Same repository
At least once exported and re-imported
Unique classes and Objects
32. How do you enhance performance?
Supervisor: delete outdated documents
BO: Use off line mode & use presentation cache
33. Explain the architecture of WebI
34. Explain the architecture of WIQT
35. Have do you design a DW from Erwin model or OLTP?
Star
Snowflake
36. What are confirmed Dimensions?
37. What are aggregate Tables?