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

What is workflow manager?

0 Answers  

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

What is a poling?

2 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 A complex mapping?

3 Answers   TCS,

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

explain about informatica server architecture?

1 Answers   IBM,

---

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers  

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

---

 Informatica Checkpoints

0 Answers   DELL,

---

how to get the only updated records in the target

2 Answers  

---