Interested to Buy Any Domain ? << Click Here >> for more details...
what are fact tables and dimension tables?
give example assuming one table.
- 3 Answers
- 8616 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 is flow of project?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Difference between in process and inter process?
What is the difference between account and directory options ?
How many types of views are there in a datastage director?
How you Implemented SCD Type 1 & Type 2 in your project?
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)
What is a merge in datastage?
What are the components of datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
If you want to use the same piece of code in different jobs, how will you achieve it?
How complex jobs are implemented in datstage to improve performance?
How do you import and export data into datastage?
What are some different alternative commands associated with "dsjob"?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
