What is the architecture of ur project? can u explain it? PLz
- 1 Answers
- 3197 Views
- Patni, I also Faced
- E-Mail Answers
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
Is there any other repository domains rather than universe, security, document?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What would you consider as your biggest achievement and why?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
What is the profile and package?
Explain is there any other repository domains rather than universe, security, document?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
What is the difference between the public object&schema object?
What is difference between custom hierarchy and report based hierarchy?
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)?
What is object stores?
Which versions are used in the bo dashboard work?
How to generate the report from excel sheet?
When to use local filter and when to use global filter?
