Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimension table?
- 17 Answers
- 33245 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 |
How to Explain My project flow,In TCS ased me this question. In which way i can start my project flow and they asked how many fact tables and dimensional tables u used. Can any one Explain Briefly for this question and project architecture also.. please..
3 Answers CTS, HCL, Infosys, TCS,
who to split dimentions into sub dimention
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Write the unconnected lookup syntax?
What is a connected transformation?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
What is xml source qualifier transformation in informatica?
what is diff between grep and find
Differentiate between sessions and batches?
What is the difference between informatics 7x and 8x and what is latest version?
In which scenario did you used pushdown optimization?
how do u tune queries?
Teradata 
