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
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what is the difference between informatica6.1 and infomatica7.1
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is the size of u r source(like file or table)?
What is decode in informatica?
What are the reusable transformations?
What are active and passive transformations?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the difference between Active and Passive transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the new features of informatica 9.x developer?
What do mean by local and global repository?
Explain sessions and how many types of sessions are there?
Briefly define reusable transformation?
Can we get 1st record through Informatica(without sequence number).
