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
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the difference between a repository server and a powerhouse?
What are Dimensional table?
Informatica Checkpoints
wf dont have integration severances how you can run?
Describe data concatenation?
How might you approve all mappings in the archive all the while?
Explain the types of lookup transformation?
What is the way to execute pl/sql script using informatica mapping?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
how tokens will generate?
What is data transformation manager process?
Could you explain what is enterprise data warehouse?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is update strategy transform?
