Answer Posted / 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 |
Post New Answer View All Answers
Difference between Target-based loading and constraint-based loading?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to use pmcmd utility command?
How can you increase the performance in joiner transformation?
What is a repository? And how to add it in an informatica client?
What do you mean incremental aggregation?
When do you use sql override in a lookup transformation?
Why do we need informatica?
Differentiate between Load Manager and DTM?
What are the different options available for update strategy?
server hot-ws270 is connect to Repository B. What does it mean?
How do you load unique records into one target table and duplicate records into a different target table?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the static cache and dynamic cache in informatica?
