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

in performance wise union is past,union all is past

2 Answers  

---

what is data driven?

1 Answers  

---

can u any challenge your project?

0 Answers   HP,

---

How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

what is work of PUSH DOWN option

2 Answers   Wipro,

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

---

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

2 Answers   Sonata,

---

why we are using surogate key in real time give me explanation

2 Answers   TCS,

---