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

How the facts will be loaded? explain

2 Answers   HCL,

---

Briefly define reusable transformation?

0 Answers  

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

Can you copy the session to a different folder or repository?

1 Answers  

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

---

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

How to update records in Target, without using Update Strategy?

3 Answers  

---

What is workflow monitor?

0 Answers  

---

How might you approve all mappings in the archive all the while?

0 Answers  

---