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
- 13476 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
Describe the impact of several join conditions and join order in a joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what is diff b/t sorter t/r and agg have the option sorter property...
How can a transformation be made reusable?
Make a note of the quantity vaults made in informatica?
Explain the different lookup methods used in informatica?
define galaxy repository in informatica
How to use procedural logic inside infromatica?
Briefly describe lookup transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
When do you use sql override in a lookup transformation?
What is meant by pre and post session shell command?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
