what is the main difference between sorragate key n primary
key in one word
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 |
HOW CAN WE SEE THE DATA IN DATASET?
How did you reconcile source with target?
What are the features of datastage flow designer?
How rejected rows are managed in datastage?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
In which situations we can use normal and sparse lookup stages
How can you join flat file, oracle as a sources?
What are the third party tools you used in your project?
I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?
I have a few records all are same structures data, I want to store data in multiple targets how?
How to read the length of word in unix?