Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

what is dimension table?

Answers were Sorted based on User's Feedback

what is dimension table?..

Answer / amit

dimension table contain the detail information abt facts
e.g customer name ,custmer address etc

Is This Answer Correct ?    43 Yes 4 No

what is dimension table?..

Answer / sandhya

a dimension table is one which contain master data
all the data in the fact is related to the data in the

Is This Answer Correct ?    31 Yes 3 No

what is dimension table?..

Answer / shivaleela

Dimensional Table:-It contains detailed information of one
Particular department

Eg:-Customer dimension it contains all the information
about the customer like name,place,DOB, city n so on along
with one primary key.

Is This Answer Correct ?    15 Yes 5 No

what is dimension table?..

Answer / venkat

dimension tables contains described data

Is This Answer Correct ?    12 Yes 5 No

what is dimension table?..

Answer / krishna

a dimension table contains the master data pertaining to a
subject area. this table is referenced by the fact table
when it is loaded.

Is This Answer Correct ?    11 Yes 4 No

what is dimension table?..

Answer / sudheer kumar

A dimension table is table Which contains detailed
Information of Particular Unit, Dimension table contains
primary key which represents uniqueness of that table,
A foreign key of fact table References primary key of a
dimension table in many to one relationship.

Consider Time Dimension, it Contains detaild time
information like,

Is This Answer Correct ?    7 Yes 2 No

what is dimension table?..

Answer / parthasarathi swain

A Dimension table is a table that contains detailed and
consistent data ie those data that are not frequently
changing in the other words we can say those as master data.
We use the primary key of the dimensional table as the
foreign key in the fact table. For one fact table we can
have more than one dimensional table.

Is This Answer Correct ?    7 Yes 2 No

what is dimension table?..

Answer / maruthi


Is This Answer Correct ?    9 Yes 5 No

what is dimension table?..

Answer / shyam shah

A dimension table is a table in a star or snowflake schema
that stores attributes that describe aspects of a dimension.
For example, a time table stores the various aspects of time
such as year, quarter, month, and day. A foreign key of a
fact table references the primary key in a dimension table
in a many-to-one relationship.

Is This Answer Correct ?    6 Yes 2 No

what is dimension table?..

Answer / ignacy

dimension table is a structure

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

How we can use union transformation?

0 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

What is the difference between stop and abort in informatica

0 Answers   Informatica,

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how

1 Answers   IBM,

What is union transformation in informatica?

0 Answers  

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 Answers  

What are the ETL tools available in DWH?

6 Answers   Mphasis,

What are the tasks that source qualifier perform?

0 Answers   Informatica,