Interested to Buy Any Domain ? << Click Here >> for more details...
What is a surrogate key?Why we use it in a mapping?Pl give
an example.
- 4 Answers
- 12293 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 rank transform?
Explain what are the different types of transformation available in informatica.
Write the different tools in the workflow manager?
How to improve the performance of a session using sorter transformation?
What is sq transformation?
How many ways are there to do 'remove duplicate records in informatica'?
What is option by which we can run all the sessions in a batch simultaneously?
How to use procedural logic inside infromatica?
Define sessions in informatica etl?
What do think which one is the better joiner or look up?
What is meant by target load plan?
is it possible to index the data in cache of lkp transformation ?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What are the new features of informatica 9.x in developer level?
