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 to export or import the jobs in .ISX file
Difference between server jobs & parallel jobs?
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
what is time dimension? and how to populate time demension
Differentiate between odbc and drs stage?
How do you remove duplicate values in datastage?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
how to run jon in unix back round process what is command use in runing a job?
How to perform incremental load in datastage?
plz tell me some dimentional and fact table names in banking project?
What are the different database update actions available?
when u face critical situation in ur project, how to solve them?