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
- 12430 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
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is standalone command task?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is an active transformation?
What is a joiner transformation and why it is an active one?
my source is junk data how will u remove that junk data by using unix please any one replay me
What are the new features of informatica 9.x at the developer level?
What are the types of presistent cache in look up tr.
How to handle decimal places while importing a flatfile into informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Mention few advantages of router transformation over filter transformation.
What is session task and command task?
What is an aggregator transformation?
