Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8556 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain ibm infosphere information server and highlight its main features?
What is orabulk stage?
What are the stages in datastage?
Describe link sort?
what is the difference between == and eq in UNIX shell scripting?
project Steps,hits, Project level HArd things,Solved methods?
What are the functionalities of link partitioner?
How do you import and export data into datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How the ipc stage work?
what is the use of materialized view?
Is the value of staging variable stored temporarily or permanently?
What is the use of hoursfromtime() function in transformer stage in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
how to delete one row in target dataset
