what is data modelling? what are types of modelling?In
which suituation will use each one?
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
What is data caches/ index caches?
What is status code in informatica?
What is xml source qualifier transformation in informatica?
where to store informatica rejected data?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Enlist some properties of sessions.
What does cheating measurement mean?
Differentiate between Load Manager and DTM?
What are the issues you have faced in your project? How did you overcome those issues?
What is deployment group?
What is the difference between a repository server and a powerhouse?
If informatica has its scheduler why using third party scheduler?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Partition, what happens if the specified key range is shorter and longer