Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what are surrogate keys?

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


Please Help Members By Posting Answers For Below Questions

Is there any target staging area in informatica not staging area

2580


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066


Can we create a node as a gateway node and the same node can be assigned to a grid?

1079


How to load a Dimension ? and how to load a fact table?

1418


What is the use of source qualifier?

1138


Explain in detail scd type 2 through mapping.

1041


tell me 5 session failure in real time how can you solve that in your project?

2305


What is meant by lookup transformation? Explain the types of lookup transformation?

952


Clarify the aggregator change?

1030


What is mapping debugger?

1016


What is the format of informatica objects in a repository?

1019


What is the different lookup cache(s)?

1086


What is mapplet in informatica?

1057


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

2121


What is a sorter transformation?

1102