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
- 9876 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
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain pushdown optimization $pushdownconfig parameter - informatica
Is there any target staging area in informatica not staging area
State the differences between sql override and lookup override?
What are the different transaction levels available in transaction control transformation?
Define the various join types of joiner transformation?
What is the difference between router and filter?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
Define sessions in informatica etl?
What is meant by active and passive transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Describe an informatica powercenter?
Separate from a database, an information bazaar, and an information stockroom?
wat are deployement groups in informatica, how it will be used for developers
What is standalone command task?
