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
Explain the difference between mapping parameter and mapping variable?
What is a stored procedure transformation?
Difference between Data and Index Caches?
r u done any partitions in ur project?
What differs when we choose the sorted input for aggregator transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Explain what is informatica metadata and where is it stored?
How does the aggregator transformation handle null values?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is joiner transformation in informatica?
What is data movement mode in Informatica and difference between them?
When do you use sql override in a lookup transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What does role playing dimension mean?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
