Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimension table?
- 17 Answers
- 32129 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / uday
a dimension table contains descriptive attributes which are
typically textual field or numeric data that behaves as text
field
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / hidayathulla
A table which contains both current and historical data is
the dimensional table.
| Is This Answer Correct ? | 4 Yes | 6 No |
Answer / amedela chandra sekhar
Dimension table it consist master data and Non-numeric data
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / senthilkumar
Table which contains important business entities called
Dimension Table.
Dimension Tables are also called as Lookup or Reference
Table
| Is This Answer Correct ? | 5 Yes | 10 No |
Answer / giri
dimetion table is havig decriptive data about u r
bissiness, it having more no row
| Is This Answer Correct ? | 3 Yes | 10 No |
Answer / mahesh
it contains charactetistic data,with is one we can see
summarised data
for example profit fact table can see by using time dimension.
| Is This Answer Correct ? | 1 Yes | 11 No |
Answer / kunal
dimesion is nothing but structure,it contains tables and
structure
| Is This Answer Correct ? | 8 Yes | 29 No |
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
If we are using an aggregator but forget to mention the group by port .what will be the output??
Explain the code page compatibility?
What do you mean incremental aggregation?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
what is mapping parameter and mapping variables
What is a test load?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
How to elaborate tracing level?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
Teradata 
