what are surrogate keys?
- 5 Answers
- 10068 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 |
What is the default source option for update stratgey transformation?
What is lookup transformation?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
what is the size of u r source(like file or table)?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Without source how to insert record to target?
What are the basic needs to join two sources in a source qualifier?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
Teradata 
