GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 40 of 93    Print  
1) what is datawarehouse architecture?
2) Informatica Architecture?
3) what is unit testing?
4) what is type2 version dimension?

  
Total Answers and Comments: 2 Last Update: February 10, 2007     Asked by: venki 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
October 17, 2006 01:03:50   #1  
srinivas vadlakonds        

RE: 1) what is datawarehouse architecture?2) Inf...

1) Data warehousing is the repository of intgrated information data will be extracted from the heterogeneous sources. Data warhousing architecture contains the different  sources like oralc,flat files and ERP then after it have the staging area and Datawarehousing, after that it has the different Data marts then it have the reports and it also have the ODS - Operationa Data Store. This complete architecutre is called the Data warehousing Architecutre.

2)Informatica Architecture contains Repository,Repository server,Repository server administration console,sources,repository server and Datawarehousing and it have the Designer,Workfow manager, workfor monitor combination of all these are called Informatica Architecture.

3) The Developer created the mapping that can be tested independently by the developer induvidually.

4)Version dimention is the SCD type II in real time it using because of it will maintain the current data and full historical data.


 
Is this answer useful? Yes | No
February 10, 2007 06:29:58   #2  
jyothi        

RE: 1) what is datawarehouse architecture?2) Inf...
1) Data Warehouse architecture is a three tire architecture where there are three tires i) bottom tire : it contains the gateways where they provide the interface b/w the data and the s/m ii) middle tire : it is the olap servers which is the actual provider of the services to the user requirements iii) top tire : it contains the actual user interface like the reporting, graphs
 
Is this answer useful? Yes | No

 Related Questions


 Sponsored Links

 
Related Articles

N-Tier Architecture: Data Access Layer

N Tier Architecture Data Access Layer In an N Tier architecture the data access layer consists of components that aid one in the process of accessing the database When it is used correctly the data access layer serves as an abstract level for the structures of the database Simple changes that are ma
 

N-Tier Architecture: The Business Rules Layer

N Tier Architecture The Business Rules Layer Business Rules Layer in N Tier Architectures The Business Rules Layer in an N Tier architecture is that layer that contains the Business logic and or Business rules of the application Reserving a separate layer strictly for Business logic in an N Tier arc
 

N-Tier Architecture Presentation Logic Layer

N Tier Architecture Presentation Logic Layer Composition of the Presentation Layer The Presentation Layer in an N Tier structure is commonly referred to as the client” layer It consists of parts that are used to present data to an end user Examples of components on the Presentation Layer
 

SOA and Business Architecture

SOA and Business Architecture Businesses are now having to think a lot more seriously about how to best assemble their systems out of common parts Service Oriented Architecture has caused this change in the way such systems are thought of It requires a lot more planning and investment at the outset
 

SOA and Network Management Architecture

SOA and Network Management Architecture In recent years the field of Network Management has been absorbing the principles of Service Oriented Architecture Examples of service oriented Network Management architectures include the TS 188 001 NGN Management OSS Architecture from ETSA as well as the mor
 

SOA Architecture

SOA Architecture It is essential for the Businesses to think a lot more seriously about how best to assemble their systems out of common parts It requires a lot more planning and investment at the outset but it also enables Businesses to build faster systems in the long run as the inventory of reusa
 

N-Tier Client-Server Architecture

N Tier Client Server Architecture Description of 1 Tier and 2 Tier Web Applications This article will discuss the various architectures of Client Server environments Perhaps the most influential Client Server environment is the Internet and its global users With the increasing use of web application
 

Peer-to-Peer and Client-Queue-Client Architecture

Peer to Peer and Client Queue Client Architecture Client Server Architecture Compared with Peer to Peer and Client Queue Client Architecture Client Server Architecture Client Server Architecture which is the model for Internet communication separates client programs machines from server programs mac
 

What is Common Data Architecture

Business need to define their organizational rules, policies and process in order to realize their projected growth within a specified period. In order to realize these targets, the essentially need to have a basic framework as the guide in their operations. The gathering and use of data is a very s
 

What is Data Architecture

Data Architecture basically deals with designing and constructing data resource. Data Architecture provides methods to design, construct and implement a fully integrated, business-driven data resource that include real world objects and events, onto appropriate operating environments. Data Architect
 

Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape