Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
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 are junk dimensions?
What is domain and gateway node?
What are the components of Informatica? And what is the purpose of each?
Different qualification between a related rotate toward the sky and isolates look upward?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is workflow? What are the components of the workflow manager?
How we can use union transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Explain the aggregator transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are pre and post-session shell commands?
Write the advantages of partitioning a session?
What is the difference between Active and Passive transformation?
What is a sorter transformation?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?