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
- 12421 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 are the types of schemas we have in data warehouse and what are the difference between them?
Make a note of the quantity vaults made in informatica?
What is the advantage of informatica?
How to update or delete the rows in a target, which do not have key fields?
What is a dimensional model?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Can you generate sequence numbers without using the sequence generator transformation?
How can we store previous session logs?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Explain joiner transformation in informatica
Which transformation is needed while using the Cobol sources as source definitions?
In development project what is the process to follow for an etl developer from day1
Enlist the differences between database and data warehouse.
How union transformation is used?
State the differences between sql override and lookup override?
