Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8554 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of views in datastage director?
What is the difference between hashfile and sequential file?
Explain entity, attribute and relationship in datastage?
What is the difference between account and directory options ?
What is staging variable?
What is the process of killing a job in datastage?
How many types of hash files are there?
What are the job parameters?
Define Data Stage?
What are transforms and what is the differenece between routines and transforms?
Describe link sort?
What is a ds designer?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Explain the importance of surrogate key in data warehousing?
in oracle target stage when we use load option and when we use upsert option?
