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 the difference between datastage and informatica?
how to handle null values in sequential file?
what is sparse lookup?
what is the definitions for Datawarehose and Datamart?
If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records
Difference between data warehousing and olap?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
how to do pergformence tuning in datastage?
when will you go for dataset and fileset?
what are the devoleper roles in real time? plz tell i am new to datastage....
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?