Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
- 2 Answers
- 8879 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 |
star and snowflake schema?
What is informatica?
what is dimension table?
what is target load plan
In ur current projectu have done any performance tuning of mappings?
Did u used latest transformations of 8.6.0? for what?
What is the difference between bitmap and btree index?
what is threshold error in informatica?
what is the predefined port in dynamic lookup
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
In informatics server which files are created during the session rums?
How to run a session, which contains mapplet?
Teradata 
