Answer / jaspreet banga

There are lots of answer for this question but i will give
you simple one, 'JUST CONSIDER A PEN, NOW SALES OF THAT PEN
IS FACT I.E., A METRICS , A MEASURABLE QUANTITY,.
what is the name of brand, its date of manufac,expiry
date, ie., DESCRIBING FEATURES are different DIMENSIONS,
i.e., SOMETHING WHICH DESCRIBES THE PEN.--hence fact tables
contains 2 things the" foreign keys from differnt dimension
table and the METRICS " while all describing features are
available in the dimenasion table. hope this clears your
concept..

Answer / boopalan venugopal

THANKU SO MUCH Jaspreet, U have given a gr8 example, which always be in my mind....thanks again..

how we load the data from source to staging area

4 Answers   TCS,

---

how i will stop my workflow after 10 errors

1 Answers   HP,

---

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

---

Can we have a Mapping without a Source Qualifier?

14 Answers   Deloitte,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

Mention few power centre client applications with their basic purpose?

0 Answers  

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

0 Answers  

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

define galaxy repository in informatica

0 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---