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 differs when we choose the sorted input for aggregator transformation?
can we override a native sql query within informatica? How do we do it?
Partition, what happens if the specified key range is shorter and longer
Target increases every day even though no new record was inserted
How can you generate reports in informatica?
how to load rows into fact table in data warehouse
what is the difference between informatica6.1 and infomatica7.1
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How can we update a record in the target table without using update strategy?
How do you load alternate records into different tables through mapping flow?
What is a passive transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
How will the document be delivered to me?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
