Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8758 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 process model?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
What is use Array size in datastage
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
Hi Vijay here For Four CPU's how many nodes will required?
What is meta stage?
HOW CAN WE SEE THE DATA IN DATASET?
Where the datastage stored his repository?
How do u view log file for a particular job?
What is the difference between passive stage and active stage?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
What is the version control how can i apply this in DataStage can any one tell me the anser
Teradata 
