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
Is there any target staging area in informatica not staging area
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Can we create a node as a gateway node and the same node can be assigned to a grid?
How to load a Dimension ? and how to load a fact table?
What is the use of source qualifier?
Explain in detail scd type 2 through mapping.
tell me 5 session failure in real time how can you solve that in your project?
What is meant by lookup transformation? Explain the types of lookup transformation?
Clarify the aggregator change?
What is mapping debugger?
What is the format of informatica objects in a repository?
What is the different lookup cache(s)?
What is mapplet in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is a sorter transformation?