Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimension table?
- 17 Answers
- 32832 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 data driven in update strategy transformation?
how to load duplicate row in a target
how can we run workflow with pmcmd?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
What is source qualifier transformation?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
What is the difference between STOP and ABORT options in Workflow Monitor?
What is substr in informatica?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep
what is target update override and when we use it?
What are the circumstances that infromatica server results an unreciverable session?
Teradata 
