Interested to Buy Any Domain ? << Click Here >> for more details...
what is the main difference between sorragate key n primary
key in one word
- 2 Answers
- 11607 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is size of a transaction and an array means in a datastage?
On which interface you will be working as a developer?
How many areas for files does datastage have?
Does datastage support slowly changing dimensions ?
What is the purpose of pivot stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the difference between operational data stage (ods) and data warehouse?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
State the difference between an operational datastage and a data warehouse?
How do you import and export the datastage jobs?
Can you explain engine tier in information server?
what is the use of materialized view?
root tree will find which is server job and which is parallel job?
Have you used Unstructured data?
What are the types of views in datastage director?
