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
- 9781 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 aggregator transformation in informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is decode in informatica?
What is the session task and command task?
Different sorts of metadata that stores in the storage facility?
can we override a native sql query within informatica? Where do we do it?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
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
What do you understand by SOA of Informatica?
what are 3 tech challenges/ common issues you face?
Difference between Target-based loading and constraint-based loading?
What is the sql query overwrite in source qualifier in informatica
How do you handle two sessions in Informatica
What is joiner change?
