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 dense rank?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How would you format some text using css to be verdana and bold?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
What Is The Difference Between Oltp And Olap?
What is Indexing? how did u implement indexing?
What is object stores?
explain in detail about type 3?
Give some information on report bursting?
Explain in detail about type 2(scd),
Difference between b.o 5.1 and 6.1b?
what is the difference b/w the refresh and buffered data?
Explain how to execute the plsql procedure from the report by clicking with mouse?
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)?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?