what is the main difference between sorragate key n primary
key in one word
- 2 Answers
- 10342 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nagaraz
surrogate key is an artificial identyfier for an entity.in
surrogate key are generated by the system sequentially.
primary key is a natural identifier for an entity.in
primary key are all the values are enterd manually by the
which are uniquely identifier there will be no repetion of
data
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rajeshchunduri
surrogate key is identifier for the values in entity
generated by system.primary key is generated manually for
the values in entity
| Is This Answer Correct ? | 6 Yes | 0 No |
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
How many types of hash files are there?
How to reverse the string using SQL?
Difference between server jobs & parallel jobs?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Describe the main features of datastage?
how to unlock a locked job in datastage 8.0
how to find out number of records imported into source file?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
Teradata 
