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
- 9931 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 |
How to load the data from people soft hrm to people soft erm using 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.
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
what is song in infrmatica...?
what is informatica metadata?
how to through logic of informatica using the push down optimization into oracle.
How we can create indexes after completing the load process?
What is the function of union transformation?
What are the differences between source qualifier and joiner transformation?
What is InformaticaPowerCenter?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
Teradata 
