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 can repository reports be accessed without sql or other transformations?

1235


On which transformations you created partitions in your project?

1358


Quickly characterize reusable change?

1131


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1145


What are the different lookup cache(s)?

1129


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6197


What is an expression transformation?

1030


What are the new features of Power Center 5.0?

1790


What is the different lookup cache(s)?

1096


What are ETL Tools?

1128


difference between informatica 8.1.1 and 8.6

3685


Clarify the utilization of aggregator cache record?

1013


Describe data concatenation?

1089


What are mapplets? How is it different from a Reusable Transformation?

1105


Explain the shared cache and re-cache?

1128