Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
- 2 Answers
- 10118 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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..
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / boopalan venugopal
THANKU SO MUCH Jaspreet, U have given a gr8 example, which always be in my mind....thanks again..
| Is This Answer Correct ? | 1 Yes | 1 No |
Is there any way to read the ms excel datas directly into informatica?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
Define update strategy?
How do you implement unconn. Stored proc. In a mapping?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Which one is better performance wise connected/un-connected lkp?why?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How to join three sources using joiner?
What is a difference between complete, stop and abort?
how i will stop my workflow after 10 errors
what is the complex transformation you used in informatica
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Teradata 
