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
- 13285 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
What is informatica powercenter repository?
In warehouses how many schemas are there?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to load a Dimension ? and how to load a fact table?
What is dimensional table?
What do you mean by enterprise data warehousing?
Whats there in global repository
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Difference between Target-based loading and constraint-based loading?
What is native users?
What is dynamic cache?
can anyone explain me about retail domain project in informatica?
Why update strategy and union transformations are active? Explain with examples.
How to generate sequence numbers without using the sequence generator transformation?
