Answer Posted / sandeep.t nizamabad
THE ARCHITECTURE CONTAINS THE FOLLOWING COMPONENTS
1.OLTP SYSTEMS
2.STAGING LAYER
3 DATA WAREHOUSE
4.DATA MARTS
5.REPORTS
6.BUSINESS USERS
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Explain what are the various reporting tools in the market?
Explain why dimenstion tables are denormalized in nature?
Explain how many ways you create ports?
I have two universes created by two difference database can we join them in designer & report level? How
What is Discrete and Continuous data in Data mining world?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
Explain what is the difference between stop and abort?
if you use oracle sql*loader , how do you transform data with it during loading?
What are components of report studio?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Where we use surrogate key explain with example?
What are situations where snowflake schema is better than star schema when the opposite is true?
What are the stages that are required in data warehousing?
What is perform recovery?
