Interested to Buy Any Domain ? << Click Here >> for more details...
what is data modelling? what are types of modelling?In
which suituation will use each one?
- 1 Answers
- 13407 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / mike
Data modelling: It is the process of designing a a datamart
or dataware house. there are three phases in data modeling
1)conceptual designing:In this phase the database
architects and the managers will understand the client
requirements. After understanding the requirements they
will identify the attributes and entities(colomns and
tables)
2)Logical designing:In this phase the dimension tables and
the fact tables are identified and also the relation ship
between the fact and dimension tables will gets identified.
Now the schema looks like either a star or snowflake
schema. To perform logical designing we use data modelling
tools like ER STUDIO or ERWIN.
3)Physical designing: Once the logical designing is
approved by the client it will be converted in to physical
existance in the database.
Hope this helps
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
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 ?
How you can differentiate between connected lookup and unconnected lookup?
Explain the aggregator transformation?
Differentiate between source qualifier and filter transformation?
What is DR strategy for Informatica project?
waht type of interface is used for testing the data in informatica
What is meant by pre and post session shell command?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
what is size of u r database?
How to convert multiple rows to single row (multiple columns) in informatica
What is mapping debugger?
What you know about transaction control transformation?
How union transformation is used?
