what are fact tables and dimension tables?
give example assuming one table.
Answer Posted / ramesh
A Fact table is a table that contains the measures of
intersert.
A dimensional table is a collection of hierarchies and
categories along which the user can drill down and drill
up. it contains only the textual attributes.
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is difference between symmetric multiprocessing and massive parallel processing?
What are stage variables and constants?
Define Merge?
What are the partitioning techniques available in link partitioner?
How do you import and export the datastage jobs?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
describe the Steps to confiure a Qlogic switch
What is the difference between account and directory options ?
Name the different sorting methods in datastage.
How to reverse the string using SQL?
What is ds designer?
What a datastage macro?
How do you reject records in a transformer?
What are some prerequisites for datastage?
Describe the architecture of datastage?