what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 7432 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / kathyayini
fact table is the collection of foriegn keys corresponding
primary keys in the dimention tables
dimention table is the table which contains primary key and
will give detail informati1on about perticular instance
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
How to delete the data in dataset?types of deleting the data in dataset?
what is data mapping
Can we use Round Robin for aggregator?is there any benefit underlying?
what is the function in Transformer stage can act as Rank function in Oracle
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
Explain Quality stage?
What is the difference between an operational datastage and a data warehouse?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
is it possible to access the same job by two users at a time in DataStage?
What is the difference between Datastage 7.5 and 7.0?
what is executable in DataStage?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
Teradata 
