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
- 10026 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 the difference between router and filter?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to create or import flat file definition in to the warehouse designer?
list out all the transformations which use cache?
What do mean by local and global repository?
Did u used latest transformations of 8.6.0? for what?
without table how to come first record only in oracle?
What are the settings that you use to configure the joiner transformation?
What is a sorter transformation?
Explain the different kinds of facts.
What are the limitations of joiner transformation?
whats the logic to load the lower level of granularity of data to fact table.
What is the reusable transformation?
