what is data modelling? what are types of modelling?In
which suituation will use each one?
- 1 Answers
- 12813 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
how we can load rejected record's at run time?(not through bad files)
What is workflow manager?
What is a stored procedure transformation?
Tell me about MD5 functions in informatica
What is a sequence generator transformation?
difference between informatica 8.1.1 and 8.6
What is the need of etl tools?
What is the difference between informatics 7x and 8x and what is latest version?
Clarify the utilization of aggregator cache record?
What are some examples of informatica etl programs?
What is a joiner transformation?
What is the cumulative sum and moving sum?
How to do unit testing in informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
write a query to retrieve the latest records from the table sorted by version(scd)
