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 |
What is a delta record? How you will read it?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
which is the most complex job in your career? Please tell me answer?
Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?
I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
What is process model?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
How to create user defined environment varibale(parameter)?
What is size of a transaction and an array means in a datastage?