what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 7692 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 |
Can you explain kafka connector?
What is a merge?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Triggers,VIEW,Procedures
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
what is a force compile
Which algorithm you used for your hashfile?
What is the precedence of stage variables,derivations, and constraints?
How many types of hash files are there?
What is the version control how can i apply this in DataStage can any one tell me the anser
how to cleansing data
What are sequencers?
Teradata 
