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?

Answers were Sorted based on User's Feedback



what are surrogate keys?..

Answer / sai suresh

surrogate key is an artificial key , it will generate
automatinclly in sequence it will act as a primary key when
the data is heighly denormalized.

Is This Answer Correct ?    0 Yes 0 No

what are surrogate keys?..

Answer / shiva

surrogate key is a artificial key or system generated
key.when ever a primary key violation occurs,by using
sequence generator t/m we generate surrogate keys

Is This Answer Correct ?    0 Yes 0 No

what are surrogate keys?..

Answer / reddy

surrgate key is not used for the bussiness

Is This Answer Correct ?    0 Yes 0 No

what are surrogate keys?..

Answer / 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

what are surrogate keys?..

Answer / pradeep

surrogate key is an autogenerated sequence in data warehouse
acts as primary key as the data in warehouse is highly
denormalised form.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

Why do you use Mapping Parameter and mapping variable?

0 Answers  


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,


How to update records in Target, without using Update Strategy?

3 Answers  


Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,


What is difference between a connected look up and unconnected look up?

6 Answers  


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


What are the two modes of datamovement in informatica sever?

2 Answers  


What is confirmed dimension and fact?

7 Answers  


where actually the usage of push down optimization happens...

2 Answers  


hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  


Is it possible to use a client with different version than that of its Informatica server?

0 Answers  


Categories