what is difference between dimention table and fact table?



what is difference between dimention table and fact table?..

Answer / guest

dimensional table stores the textual description of data
whereas fact table stores numerical values.

Is This Answer Correct ?    12 Yes 3 No

Post New Answer

More Informatica Interview Questions

Why we use partitioning the session in informatica?

2 Answers  


What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,


How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,


What are the different threads in DTM process?

1 Answers  


Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.

2 Answers  






can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  


Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,


What is a mapplet/worklet in informatica?

0 Answers  


How the facts will be loaded? explain

2 Answers   HCL,


In development project what is the process to follow for an etl developer from day1

0 Answers  


in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


Categories