what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 7404 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
What are the enhancements made in datastage 7.5 compare with 7.0?
What is meta stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
How many areas for files does datastage have?
How can we improve performance of data stage jobs?
What is use Array size in datastage
What is the difference between the local container and shared container?
What are the different kinds of views available in a datastage director?
How can one find bugs in job sequence?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
explain about citrix scheduling tool in datastage
What is the difference between informatica and datastage?
Describe routines in datastage? Enlist various types of routines.
in oracle target stage when we use load option and when we use upsert option?
