What is surrogate key?
- 9 Answers
- 23915 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 |
What are active and passive transformations?
what is the look up transformation?
How do you load only null records into target? Explain through mapping flow.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
What is dynamic cache?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Teradata 
