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

If there are more than one sessions running parallel in a worklet, which will be the last session ?

2 Answers  

---

What is the function of look up transformation?

0 Answers  

---

How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.

9 Answers   Barclays,

---

disable caching in a lookup transformation?

1 Answers  

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

---

What is the difference between a router and a filter transformation?

1 Answers   TCS,

---

what is lookup chache?

1 Answers   Patni,

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

what is galaxy repository?

2 Answers  

---

What is the different lookup cache(s)?

0 Answers  

---

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---