Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimension table?
- 17 Answers
- 32128 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / sandhya
a dimension table is one which contain master data
all the data in the fact is related to the data in the
dimension.
| Is This Answer Correct ? | 31 Yes | 3 No |
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 |
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 |
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.
Example:
Consider Time Dimension, it Contains detaild time
information like,
YYMMDD,YYMM,YYYY,YYQQ,YYWK.(Year,quarter,Month,Daate).
| Is This Answer Correct ? | 7 Yes | 2 No |
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 |
Answer / maruthi
DIMENSION TABLE CONTAINS DISTRIBUTTED DATA OR MASTER
DATA,WHICH WE CAN ANALYZE DEPENDING ON FFACTS OR MEASURES
IN FACT TABLE.
| Is This Answer Correct ? | 9 Yes | 5 No |
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 meant by incremental aggregation?
What is power center repository?
wf dont have integration severances how you can run?
Why do we use DSS database for OLAP tools?
how we load the data from source to staging area
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
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,
what is mapping parameter and mapping variables
What are the types of lookup transformation?
What are the types of data that passes between informatica server and stored procedure?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
How you load distinct records into one target and duplicate records into another target?
Teradata 
