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
How are indexes created after completing the load process?
Design time, run time. If you don't create parameter what will happen
explain one complex mapping with logic? sales project?
Explain the aggregator transformation?
Can you generate sequence numbers without using the sequence generator transformation?
How can we delete duplicate rows from flat files?
What is an unconnected transformation?
Differentiate between router and filter transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What are the main features of Oracle 8i with context to datawarehouse?
How to do unit testing in informatica?
What are active transformations.
What is a repository? And how to add it in an informatica client?
Difference between Data and Index Caches?
What is rank index in rank transformation?
