what is the main difference between sorragate key n primary
key in one word
- 2 Answers
- 10621 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
Give an idea of system variables.
Why fact table is in normal form?
How complex jobs are implemented in datstage to improve performance?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the differentiate between data file and descriptor file?
How to find value from a column in a dataset?
What all the types of jobs you developed?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
how to delete one row in target dataset
Which commands are used to import and export the datastage jobs?
On which Dimension Table you implemented SCD Type in your Project
What are the benefits of datastage?
Differentiate between Join, Merge and Lookup stage?
How do you import and export the datastage jobs?
