What is a surrogate key?Why we use it in a mapping?Pl give
an example.
- 4 Answers
- 11175 Views
- PCS, I also Faced
- E-Mail Answers
Answer Posted / saradhi
surrogate key is used to avoid the critical column.critical
column means the column which makes the analysation or data
wrong for example assume one customer table
cust_id(p.k) cust_name amount loc
1 jones 1000 hyd
he purchase the product in hyd by 1000/- if he again
purchase by 2000/- in pune not in hyd.then we have to
create another record in that table with same cust_id but
here cust_id is having primary key so we are unable to
create a new record for suppose if u update the record u
got the wrong information as
1 jones 3000 pune
so eliminating this we are maintian the another column like
cust_no as surrogate key (unique value)and removes p.k in
cust_id.surrogate key is like an index.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is the way to execute pl/sql script using informatica mapping?
Explain lookup transformation source types in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain transaction control transformation in informatica
Difference between Data and Index Caches?
Can we create multiple integration service on single repository?
What is the difference between Active and Passive transformation?
Define pmcmd command?
What is the fact table?
Explain the shared cache and re-cache?
What differs when we choose the sorted input for aggregator transformation?
Explain lookup transformation is active in informatica
Explain in detail about scd type 1 through mapping.
What do mean by local and global repository?
Which are the different editions of informatica powercenter that are available?
