Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
what are the Methods For Creating Reusable Transformations?
How to partition the Session?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Difference between Data and Index Caches?
What is the format of informatica objects in a repository?
Explain scd type 3 through mapping.
How to open an older version of an object in the workspace?
How union transformation is used?
what is $$$$?
Write the advantages of partitioning a session?
What does refresh system mean, and what are its distinctive choice?
Which transformation should we use to normalise the COBOL and relational sources?
What is the function of union transformation?
What is the function of aggregator transformation?
How can you generate reports in informatica?
