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 we can load rejected record's at run time?(not through bad files)
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What can we do to improve the performance of informatica aggregator transformation?
What is event and what are the tasks related to it?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain sessions?
What are the different options available for update strategy?
Explain about cumulative Sum or moving sum?
How to join three sources using joiner?
Differentiate between source qualifier and filter transformation?
What do you understand by term role-playing dimension?
What is a predefined event?
How to call shell scripts from informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Describe expression transformation?