Interested to Buy Any Domain ? << Click Here >> for more details...
What is surrogate key?
- 9 Answers
- 26742 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / koti
sarrogate key is ssystem generated sequence number,an
artificial key. which can be used in maintaing the history
of the data
| Is This Answer Correct ? | 24 Yes | 3 No |
Answer / sunil kumar singh
Surrogate Key is artificial that is created for
datawarehousing for generating the unique number for each
record. Surrogate key works on the behalf of primary key.
And main purpose of surrogate key is to maintain the
historical record.
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / nivas
Surrogate key is a system generated sequence numbers. It is
also called artificial key.Sarrogate key using as a primary
key without using sarrogate key we can't do SCD type2
implemenation.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rajat singh
Surrogate key is the primary key for the Dimensional table.
Surrogate key is a substitution for the natural primary key.
Data warehouses typically use a surrogate, (also known as
artificial or identity key), key for the dimension tables
primary keys. They can use Infa sequence generator, or
Oracle sequence, or SQL Server Identity values for the
surrogate key.
It is useful because the natural primary key (i.e. Customer
Number in Customer table) can change and this makes updates
more difficult and also used in SCDs to preserve historical
data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shan
sarrogate key is ssystem generated sequence number,an
artificial key. which can be used in maintaing the history
of the data
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / ram
surrogate key
is a series of sequential numbers assigned to be foreign key
for the table
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / anil
Surrogate key is a primary key which can be used for
sequence
| Is This Answer Correct ? | 7 Yes | 7 No |
Answer / latha
actually it appears in picture when a critical
column(example location) occurs in a table.In order to avoid
the critical column we are using surrogate key.surrogate key
is also a primary key.
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / swagatika
IN DWH environment,Every dimension table is integrated with surrogate key,which is byforced created to maintain the consistancy of data warehouse targets.It never generate the alfa numeric number of primary key & also replace the missing values.
The natural primary key ,which is coming from database is considered as alternate key in DWH Environment
| Is This Answer Correct ? | 0 Yes | 0 No |
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
What is degenerated dimention table?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
Explain the shared cache and re-cache?
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
what is the purpose of surrogate key and diff between primary key&surrogate key
What are ETL Tools?
What are the uses of a Parameter file?
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
what are the types of Data warehousing ?
Teradata 
