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
- 9885 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / boopalan venugopal
THANKU SO MUCH Jaspreet, U have given a gr8 example, which always be in my mind....thanks again..
| Is This Answer Correct ? | 1 Yes | 1 No |
version controlling in informatica?
can you please explain me pre session and post session options?
To provide support for Mainframes source data,which files r used as a COBOL files
how do the project develops? pls specify right from the start to end in step by steps.
What is transformation?
State the differences between sql override and lookup override?
how to load only the first and last record of a flat file into the target?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
What are the advantages of using informatica as an etl tool over teradata?
What are the challenges you have faced in your project?
What are the scheduling options to run a sesion?
Teradata 
