explain different types of modeling.
- 2 Answers
- 10529 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pushparao
modeling is defined as to convert requirements of the business
users into technical structures.
1.conceptual modeling
2.logical modeling
3.physical modeling
example modeling tools:ERwin
| Is This Answer Correct ? | 5 Yes | 2 No |
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
Diffrence between static and dynamic cache
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
major difference between normal loading and bulk loading?
where does the default group roew in a router is stored what is the default size of memory in router
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
What is the difference between Active and Passive transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
Can we create two repositories on same database instance in oracle?
Why use shortcuts(Instead of making copies).
What is the Rank index port in Rank transformation?
what is the difference between static and dynamic
Teradata 
