Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?
- 2 Answers
- 9131 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
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
How can we update a record in the target table without using update strategy?
Can anyone tell me the new features in Informatica 9 Version?
Mention few power centre client applications with their basic purpose?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is informatica worklet?
How to create or import flat file definition in to the warehouse designer?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What differs when we choose the sorted input for aggregator transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
where to store informatica rejected data?
what is the difference between informatica6.1 and infomatica7.1
Explain the etl program with few examples.
Whats there in global repository
How to partition the Session?
