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

how we can load rejected record's at run time?(not through bad files)

2313


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

981


What can we do to improve the performance of informatica aggregator transformation?

1041


What is event and what are the tasks related to it?

1052


4 yrs etl devloper roles and responsibilities?any body give solutions

2074


Explain sessions?

977


What are the different options available for update strategy?

937


Explain about cumulative Sum or moving sum?

975


How to join three sources using joiner?

1028


Differentiate between source qualifier and filter transformation?

1508


What do you understand by term role-playing dimension?

981


What is a predefined event?

1029


How to call shell scripts from informatica?

934


what are factless facts? And in which scenario will you use such kinds of fact tables.

1738


Describe expression transformation?

1044