What is the architecture of ur project? can u explain it? PLz
Answer Posted / 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 |
Post New Answer View All Answers
What Is The Difference Between Oltp And Olap?
When to use local filter and when to use global filter?
what will be the contents for a functional requirements specifications
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Can more than 1 metric be applied on an analytic in business objects?
What are the steps to be taken to schedule the report?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
U r project in which stage in implementation?
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)?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
what is xcelsius architecture?
Explain what three things do you consider to be the most important factors for a manager?
Explain what is aggregate table and aggregate fact table ... Any examples of both?