what is dimension table?
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 |
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
if i have a delimited file as source so how can we seperate this file into three diff targets?
differences between service based and product based?
What differs when we choose the sorted input for aggregator transformation?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
What is rank transformation?
How to improve the session performance in informatica?
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
What are Business Components in Informatica?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...