Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is joiner transformation?
How to improve the performance of a session using sorter transformation?
Is there any way to read the ms excel datas directly into informatica?
What is DR strategy for Informatica project?
What are the differences between oltp and olap?
Mention a few design and development best practices for informatica?
How to delete duplicate row using informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Suppose we do not group by on any ports of the aggregator what will be the output?
Could you explain what is enterprise data warehouse?
How can you define user defied event?
How can we store previous session logs?
What is powercenter on grid?
What are the restrictions of union transformation?
