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 differences between joiner transformation and source qualifier transformation?
During the running session, output files are created by informatica server. Enlist few of them.
What is informatica powercenter repository?
Explain lookup transformation source types in informatica
Write the advantages of partitioning a session?
What is data caches/ index caches?
Scheduling properties,whats the default (sequential)
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a grid in Informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Is it possible to revert a global repository to local one and why?
How to update a particular record in target with out running whole workflow?
Name the different lookup cache(s)?
What are the different options available for update strategy?
How do you use reject loader.
