ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Data Warehouse >> Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions (183)
 Business Objects interview questions  Business Objects Interview Questions (756)
 Cognos interview questions  Cognos Interview Questions (851)
 Informatica interview questions  Informatica Interview Questions (1624)
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions (29)
 Actuate interview questions  Actuate Interview Questions (35)
 Ab Initio interview questions  Ab Initio Interview Questions (172)
 Data Stage interview questions  Data Stage Interview Questions (564)
 SAS interview questions  SAS Interview Questions (556)
 Micro Strategy interview questions  Micro Strategy Interview Questions (36)
 ETL interview questions  ETL Interview Questions (195)
 Data Warehouse General interview questions  Data Warehouse General Interview Questions (216)
Question
What is Conceptual, Logical and Physical model?
 Question Submitted By :: Data-Warehouse-General
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
Conceptual Data Model
During the Planning phase of the project, the conceptual
data model is created to capture the high-level data
requirements for the project. Since the model captures the
highlights of the clientís information needs, it is the
only model that effectively reflects the enterprise level.
Depending on the requirements, the enterprise-wide vision
may need to be emphasized to help guide the client in the
development of an overall data warehousing strategy. Detail
models that reflect the projectís scope will be created
during logical and physical data modeling. The conceptual
data model is the precursor to the logical data model; it
is not tied to any particular solution or technology.
Entities, relationships, major attributes, and metadata
across functional areas are included. During successive
releases, the conceptual data model should be validated and
updated if necessary. An enterprise should have only one
conceptual data model.
Logical Data Model
During the design phase of the project, the logical data
model is created for the scope of the complete project. A
portion of the conceptual data model will be fully
attributed and completed as the logical data model. The
logical data model reflects the technology to be used. In
todayís environment, this typically means either a
relational DBMS or a multidimensional tool. But if the
client should be using an older DBMS such as IMS or IDMS,
the logical model will be quite different than if an RDBMS
is to be used. The logical data model reflects a logical
data design that can be used by the developers on the
project. For an RDBMS, that means logical tables (views)
and columns.

Physical Data Model
Like the logical data model, the physical data model is
created during the design phase. This modeling activity
should reflect the scope of the specific release of the
project. The modelís final design will be highly dependent
on the technical solution for the data warehouse. The
purpose of this model is to capture all the technical
details required to produce the final tables, and physical
constructs such as indexes and table partitions. The
logical data model will serve as a blueprint to the project
team while the physical data model is a blueprint for the
DBAs. All the functionality reflected in the logical data
model should be preserved while creating the physical data
model. The generated table schemas will be identical to the
physical data model.
 
Is This Answer Correct ?    11 Yes 5 No
Guest
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
what are different ways of loading data to data warehouse using oracle?   1
What is data merging, data cleansing and sampling?   1
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ? Principal-Finance 3
How to use the tool Ontobulider   1
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client? CSC 1
What is Bulk Insert?   3
How can we import and export using BCP utility?   1
What are different stages of ?Data mining??   1
Explain in simple terms, the concept of Data Mining.   3
What is subject area?   2
State any 5 of Cods guidelines of an OLAP system, brief description each?   1
What is a Data Cube?   1
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright © 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com