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
- 13404 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
On which transformations you created partitions in your project?
Explain how many types of dimensions are available in informatica?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Can you use flat files in Mapplets.
Different qualification between a related rotate toward the sky and isolates look upward?
What is the difference between source qualifier transformations source filter to filter transformation?
What you know about transaction control transformation?
Define joiner transformation?
How can you increase the performance in joiner transformation?
Is there any target staging area in informatica not staging area
can you please explain me pre session and post session options?
