explain different types of modeling.
- 2 Answers
- 10360 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 source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
Roles and Responsibilties of Informatica Production Support Member?
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
major difference between normal loading and bulk loading?
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
What are the features of complex mapping?
plz plz plz send client names and project names in informatica?
in which situations do u go for sequence generator ?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
my source is junk data how will u remove that junk data by using unix please any one replay me
Teradata 
