what are fact tables and dimension tables?
give example assuming one table.

Answer Posted / srikanth

Hi this is srikanth, A fact table consists of the
measurements, facts of a business process.
Dimension table consists descriptive or meaningful
information of business process.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of containers in datastage?

703


Differentiate between operational datastage (ods) and data warehouse?

671


how to write server Routine coding?

1661


How to Remove Duplicate using SQL?

840


What is a folder? Difference types of stages?

626






Can you explain players in datastage?

701


What are the types of views in datastage director?

1243


Define Routines and their types?

618


How to reverse the string using SQL?

888


Is the value of staging variable stored temporarily or permanently?

573


What is the difference between datastage and datastage tx?

590


what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

953


Explain datastage architecture?

814


Name the third party tools that can be used in datastage?

611


How to convert RGB Value to Hexadecimal values in datastage?

3452