what is dimension table?

Answers were Sorted based on User's Feedback



what is dimension table?..

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

what is dimension table?..

Answer / hidayathulla

A table which contains both current and historical data is
the dimensional table.

Is This Answer Correct ?    4 Yes 6 No

what is dimension table?..

Answer / amedela chandra sekhar

Dimension table it consist master data and Non-numeric data

Is This Answer Correct ?    1 Yes 3 No

what is dimension table?..

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

what is dimension table?..

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

what is dimension table?..

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

what is dimension table?..

Answer / kunal

dimesion is nothing but structure,it contains tables and
structure

Is This Answer Correct ?    8 Yes 29 No

Post New Answer

More Informatica Interview Questions

Name at least 5 different types of transformations used in mapping design and state the use of each.?

0 Answers   Informatica,


How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,


What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,


8.what is mapplet ?give example?

2 Answers  


what is row level and column level indicator?

1 Answers   TCS,






hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,


how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,


Explain about Recovering sessions?

1 Answers  


Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,


How to implement security measures using repository manager?

0 Answers  


What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,


Categories