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
- 13281 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / 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 |
Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance
What are conformed dimensions?
why sequence generator should not directly connected to joiner transformation ?
What is the functionality of update strategy?
what is difference between COM & DCOM?
After we make a folder shared can it be reversed?Why?
Write the advantages of partitioning a session?
What are the designer tools for creating tranformations?
write a query to retrieve the latest records from the table sorted by version(scd)
What are active transformations.
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
wat are deployement groups in informatica, how it will be used for developers
Teradata 
