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


Please Help Members By Posting Answers For Below Questions

What is the dense rank?

679


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,

1588


How would you format some text using css to be verdana and bold?

674


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

936


What Is The Difference Between Oltp And Olap?

682






What is Indexing? how did u implement indexing?

1820


What is object stores?

583


explain in detail about type 3?

631


Give some information on report bursting?

573


Explain in detail about type 2(scd),

599


Difference between b.o 5.1 and 6.1b?

653


what is the difference b/w the refresh and buffered data?

1765


Explain how to execute the plsql procedure from the report by clicking with mouse?

602


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)?

579


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?

9882