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
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?
how get the grand total in master-detail report?
What is the difference between datawarehousing and businessintelligence?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain how many universes can be created in a project?
What three things do you consider to be the most important factors for a manager?
Can we create universe with no cache??
Explain is data mart?
How many universes can be created in a project?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
How to open a universe with out using the Designer ??
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
When to use local filter and when to use global filter?
What task is 98% of the required work of a business analyst?
What is Indexing? how did u implement indexing?