Business Model and Mapping Layer

Handson02:Business Model and Mapping Layer

1. What is the business model
1. Is the highest-level object in the BMM layer
2. Contains the business model definitions and the mappings from logical to physical tables
3. Simplifies the physical schema
4. Captures how users think about their businesses using their own vocabulary
2. Can we create business model with single logical table, if no please let me know work around.
1. Approach 1: Creating duplicate table in BMM layer
2. Approach 1: Creating alias and creating join between original table and alias
3. Can we create business model from multiple databases, did you created then tell me one scenario
1. Yes
2. Scenario: when we want to compare the Actual data with target data and these data coming from sources like oracle database and MS-Excel respectively 
4. What is the Logical Table Source and when we will go for multiple logical tables
1. Logical table sources define the mappings from single logical table to one or more physical tables. 
2. A logical table contains one or more logical table source. 
3. The mapping between physical columns and logical columns can manage using LTS
4. By integrating multiple physical tables to LTS or  By integrating multiple LTS to LT we can convert snow flake schema into star schema 
5. When we need to integrate multiple physical tables in LTS.
1. If we have snowflake schema then want to convert that into star schema then we will go for multiple logical tables.
6. Did you get chance to map a logical column with multiple physical columns
1. Yes, If we want to configure aggregate tables then we need to do it .
7. What is logical join and why it is useful?
1. A: The join defined in the BMM Layer is called logical join
1. Logical join is used to defined driving table
2. Logical Join is used to define Inner, Right, Left and Full outer joins
3. Used to defined the cardinality
4. Logical join is useful to identify dimension and fact table
5. Logical join allows Oracle BI Server to make the best decision about the exact physical SQL to generate based on the logical query path.
8. 7.Can we have a table without logical join?
1. No
9. Can we have a dimension table without primary key?
1. No
10. Can we copy RPD objects within the RPD and from one RPD to another RPD?
1.  Yes, we can copy RPD objects with in the RPD.
2. We can copy one RPD to another  RPD but we need to copy corresponding layers only i.e. (physical to physical, BMM to BMM and presentation to presentation)
11. What is Renaming wizard and which layers can be modified.
1. Renaming wizard is used to rename all objects ( example : tables and columns) of BMM and Presentation layer
2.