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
- 12370 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
How you prepared reports for OLAP?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is the different lookup cache(s)?
Mention some types of transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is joiner transformation in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
Explain the different lookup methods used in informatica?
Have you worked with/created Parameter file
What is workflow manager?
What is Data Caches size?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is joiner change?
wf dont have integration severances how you can run?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
