What is the architecture of ur project? can u explain it? PLz
Answer / pk
Architecture of the project means..
1.Your Source and Target System.Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4.Loading strategy like which u applied type 1,2 or 3.
5. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
6. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.
Is This Answer Correct ? | 0 Yes | 0 No |
Can We customize the Business Object infoview in BO?
what is crosstab reporting,slice and dise and drill mode??
What is #DATASYNC error how to remove it?
What are the errors u have faced in creating reports in business objects and explain some?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
How many universes are required for a single project,and how many reports are required for a single Universe.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How to create Index to the table in the universe designer and how it improves the Query performence
How to Implement the the Built-in Strategy Script in BO Designer?
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
How to get the data from the two different sourcess