----------------Describe DWH Architecture?
- 1 Answers
- 2143 Views
- Bank Of America, I also Faced
- E-Mail Answers
Answer / Shruti Sharma
Data Warehouse (DWH) architecture is a strategic design pattern for building an enterprise data warehouse. It consists of four layers: Source System, Staging Area, Data Integration Services, and Data Access Services.n
1. Source System: This layer includes various operational databases and external files that serve as the source of raw data. These systems generate transactional data in their day-to-day activities.n
2. Staging Area: The staging area is responsible for preparing the raw data from the source system for analysis by the end users. It acts as a buffer between the source systems and the data warehouse, where the data undergoes cleaning, transformation, and integration.n
3. Data Integration Services: This layer contains the ETL (Extract, Transform, Load) processes that move data from the staging area to the data warehouse.n
4. Data Access Services: The final layer of the DWH architecture is responsible for providing a platform for end users to access and analyze the integrated data. It includes OLAP cubes, SQL-based reporting, and other tools.
| Is This Answer Correct ? | 0 Yes | 0 No |
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
How can I schedule reports in cognos?
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
what is Governor settings in cagnos?
What is the difference between static and dynamic conditions?
I have 3 dataitems in a list username,transaction type,transaction amount. In transaction type i have 3 types 'add','update','delete', i have almost 750 rows. After displaying the list report i want to know no. of add's,update's,delete's in 3 different rows
How to a create header dynamically in a crosstab report in cognos 8.1?
------------- How to identify the Revenue Column in Report?
-----------With out using DrillThrough how to do Reports?
Part 1 : Cognos 1.What are the technologies that are used in cognos? 2.What are complex reports? 3.What is page break? 4.What is layout component? 5.How do you use extract function? 6.What is the use of Crosstab space? 7.What is Rank()? 8.What is the use of Query calculation and layout calculation? 9.What is Slicer and Dicer? 10.How can you create users in Cognos? 11.What is last child member? 12.What is the use of Conditional blocks? 13.What is Conditional Formatting? 14.What is group span? 15.In which types of reports does the page breaks applicable? Is it applicable in excel reports? 16.I want to show a up arrow and down arrow image in cross tab report, if the revenue is > 5000 (up arrow) and if <5000 (down arrow)? How will you achieve this? 17.What are types of Filters in RS? What is Summary Filter and Detail Filter? 18.What is Cast Function? 19.How will you create prompts for the example like this : In a single report I want a) List report (Need a prompt for this) b) Crosstab report (Need a separate prompt for this) c) Chart ()(Need a separate prompt for this) Part II : Framework Manager (FM) 1. What is Determinant in FM? 2. What is Cardinality? 3. What are the types of filters used in FM? 4. Can we create cubes with Relational Data sources? 5. What is Aliasing and Shortcut? 6. What is Session Parameter & Parameter Maps? 7. How many types of securities that we have in FM? 8. What is Data Security in FM? Part III : Data warehousing 1.What are various types of Schemas? 2.What is Star Schema and Snow Flow Schema? Difference between both? 3.What is surrogate key? Part IV : Databases 1.What are NVL Functions? 2.What is left outer join? Give an Example? 3.Can we straightaway use the tables that we have in the database instead of creating the package’s FM and making use of them, through Report Studio (RS)?
What is set to be cardinality?
Teradata 
