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
How to load the data from people soft hrm to people soft erm using informatica?
what are the Methods For Creating Reusable Transformations?
Can you generate sequence numbers without using the sequence generator transformation?
What is persistent lookup cache?
Sequence generator, when you move from develoment to production how will you reset
define galaxy repository in informatica
What is meant by target load plan?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain in detail about scd type 1 through mapping.
How to elaborate tracing level?
What is Index Caches size?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Explain how many types of dimensions are available in informatica?
Differences between version 7.x and 8.x.
