what is data modelling? what are types of modelling?In
which suituation will use each one?
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 |
what is fact table?
How the informatica server increases the session performance through partitioning the source?
how will you get 21 to 30 record from 50 records?
Plz can any one say me how to get the informatica certification materials and dumps
Design time, run time. If you don't create parameter what will happen
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What is source qualifier?
What is a design?
why we are using surogate key in real time give me explanation
Is it possible to update the target table with PK?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.