Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Can any one give me a real time example for FACT TABLE &
DIMENSIONAL TABLE?

Question Posted / boopalan venugopal

Answers were Sorted based on User's Feedback



Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?..

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

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?..

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

Post New Answer

More Informatica Interview Questions

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

How the dimensions will be loaded?

0 Answers   HCL,

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  

Explain what transformation and how many are there in informatica?

0 Answers  

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

with out using update strategy transnsformation how to update the data in mapping level

1 Answers  

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

What does cheating measurement mean?

0 Answers  

What is the meaning of decode in informatica?

0 Answers  

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

For more Informatica Interview Questions Click Here
Categories