Interested to Buy Any Domain ? << Click Here >> for more details...
what are surrogate keys?
- 5 Answers
- 11372 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
where to select code page option?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
Can you start a session inside a batch individually?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
how to join the two flatfiles using the joiner t/r if there is no matching port?
How can you join two tables without any common column present in them?
Explain the tuning lookup transformation - informatica
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
What is a joiner transformation?
What are the main issues while working with flat files as source and as targets ?
Teradata 
