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

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

6 Answers   Accenture,

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers  

How can you validate all mappings in the repository simultaneously?

0 Answers  




source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

What are the different caches used in informatica?

3 Answers   UST,

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

can anyone suggest best free Talend data integration training online

0 Answers  

What are the data movement modes in informatcia?

1 Answers  

what is INFORMATICA TESTING process

0 Answers  

What is partioning?how many types of partinings are there

2 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories