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 session task and command task?
What are the restrictions of union transformation?
Explian the Process of deployment groups in informatica
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to improve the performance of a session using sorter transformation?
How to generate sequence numbers?
Can we override a native sql query within informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain pmcmd command usage in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Write the different tools in the workflow manager?
What is primary and backup node?
Which are the different editions of informatica powercenter that are available?
have u done any performance tuning? how u ll do?
what is mean by complex business rule ?
