Answer Posted / deepthi pathuri
A surrogate key in a data warehouse is more than just a
substitute for a natural key.
(OR)
A surrogate key is frequently a sequential number (e.g. a
Sybase "identity column") but doesn't have to be. Having
the key independent of all other columns insulates the
database relationships from changes in data values or
database design and guarantees uniqueness.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
On which transformations you created partitions in your project?
Quickly characterize reusable change?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the different lookup cache(s)?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is an expression transformation?
What are the new features of Power Center 5.0?
What is the different lookup cache(s)?
What are ETL Tools?
difference between informatica 8.1.1 and 8.6
Clarify the utilization of aggregator cache record?
Describe data concatenation?
What are mapplets? How is it different from a Reusable Transformation?
Explain the shared cache and re-cache?