what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 7370 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 sort two columns in single job in datastage.
what is ds administrator used for?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
How a server job can be converted to a parallel job?
what is meta data? Explain? Where it is used?
whom do you report?
What is the roundrobin collector?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
What a datastage macro?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
Teradata 
