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 do you find the number of rows in a sequential file?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What modeling tool do you use?
how to define satge variables in transformer stage
HOW CAN WE SEE THE DATA IN DATASET?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
i have flat file and using unix how can i generate sequence number into targer?
To see hidden files in LINIX?
Demonstrate experience in maintaining quality process standards?
What is the difference between datastage and informatica?
Is possible to create skid in dim,fact tables?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer