Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8506 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 |
what is the use of skid in reporting?
How you Implemented SCD Type 1 & Type 2 in your project?
how can you generate sequence number using only the sequential file stage?
Why we need datasets ratherthan sequential files?
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
What steps should be taken to improve Datastage jobs?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
What is data partitioning?
how CAN we remove duplicates in dataset?
How to delete the data in dataset?types of deleting the data in dataset?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
Teradata 
