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
Clarify the aggregator change?
What are the tuning techniques you applied during your last project
Explain the shared cache and re-cache?
How to configure mapping in informatica?
expain about the tune parameters?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
what is SDLC way of code development?
Explain lookup transformation source types in informatica
What is the cumulative sum and moving sum?
Explain the tuning lookup transformation - informatica
Explain the etl program with few examples.
What is data movement mode in Informatica and difference between them?
Describe data concatenation?
What is DR strategy for Informatica project?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
