GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Informatica

 Print  |  
Question:  Dimension Table Vs Fact Table

Answer: What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica.


August 08, 2008 02:25:14 #3
 chandrasekhar.gk Oracle Expert  Member Since: August 2008    Total Comments: 1 

RE: Dimension Table Vs Fact Table
 
Dimention Table - A pure dimention table is a collection of primary keys
Fact Table        - A pure fact table is collection of foreign keys.
     

 

Back To Question