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
- 12226 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 difference between a gateway node and worker node?
How to load last n records of file into target table - informatica
How do you convert single row from source into three rows into target?
What is depict expression change?
server hot-ws270 is connect to Repository B. What does it mean?
What is the procedure for creating independent data marts from informatica 7.1?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Enlist the differences between database and data warehouse.
what are 3 tech challenges/ common issues you face?
whats the logic to load the lower level of granularity of data to fact table.
What is a filter transformation and why it is an active one?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Differentiate between router and filter transformation?
How to join three sources using joiner?
What does command task mean?
