Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
- 2 Answers
- 9918 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
State the differences between sql override and lookup override?
Can u generate reports in Informatica?
Explain how to import oracle sequence into informatica?
What is the use of target designer?
What are different types of transformations available in informatica?
Why union transformation is an active transformation?
What is a filter transformation?
What is decode in informatica?
What is a standalone command task?
What is DR strategy for Informatica project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is olap (on-line analytical processing?
What happens when a session fails and you click on recover?
