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
Repository user profiles
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What are mapplets?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Global and Local shortcuts. Advantages.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a filter transformation and why it is an active one?
What are the tasks that source qualifier perform?
What do mean by local and global repository?
What does command task mean?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is rank transformation?
Why do we need informatica?
How do you load alternate records into different tables through mapping flow?