Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / abhinaw prakash
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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
what is the -ve test case in your project.
How many number of sessions can one group in batches?
How union transformation is used?
What is the sql query overwrite in source qualifier in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
if we have a delimiters at unwanted places in a flat file how can we over come those.
How do we call shell scripts from informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Differences between connected and unconnected lookup?
How you know when to use a static cache and dynamic cache in lookup transformation?
Explain constraint based loading in informatica
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Target increases every day even though no new record was inserted
What is parallel processing in informatica?
Scheduling properties,whats the default (sequential)
