Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kshatri
There are again types of modeling:
Data modeling,
Dimension Modeling,
Multidimensional Modeling
Physical Model
Locial Model
Data Modeling: Data modeling is the process of designing a
data base model. In this data model data will be stored in
two types of table fact table, dimension table fact table
contains the transaction data, and dimension table contains
the master data
Dimensional Modeling: It is a logical design technique that
seeks to present the data in a standard, intuitive
framework that allows for high-performance access. There
are different data modelings concepts like ER Modeling
(Entity Relationship modeling), DM (Dimensional modeling),
Hierarchal Modelling, Network modelling.But popular are ER
and DM only
During the logical design phase, you defined a model for
your data warehouse consisting of entities, attributes, and
relationships. The entities are linked together using
relationships.
During the physical design process, you translate the
expected schemas into actual database structures. At this
time, you have to map:
• Entities to tables
• Relationships to foreign key constraints
• Attributes to columns
• Primary unique identifiers to primary key
constraints
• Unique identifiers to unique key constraints
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Briefly define a session task?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the main features of Oracle 8i with context to datawarehouse?
How to update or delete the rows in a target, which do not have key fields?
Separate from a database, an information bazaar, and an information stockroom?
Explain the use of aggregator cache file?
what are the deliverables?in your project?
What are different types of transformations available in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
Define joiner transformation?
How to open an older version of an object in the workspace?
How to do unit testing in informatica? How to load data in informatica ?
can we override a native sql query within informatica? How do we do it?
What is meant by a domain?
What is meant by pre and post session shell command?
