What is a surrogate key?Why we use it in a mapping?Pl give
an example.
Answers were Sorted based on User's Feedback
Answer / 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 |
surrogate key is a System generated Key ( Artificial
key ),Every join between dimension tables and fact tables
in a data warehouse environment should be based on
surrogate keys, not natural keys.
There are still more reasons to use surrogate keys. One of
the most important is the need to encode uncertain
knowledge. You may need to supply a customer key to
represent a transaction, but perhaps you donĂ½t know for
certain who the customer is. This would be a common
occurrence in a retail situation where cash transactions
are anonymous, like most grocery stores.
What is the customer key for the anonymous customer?
Perhaps you have introduced a special key that stands for
this anonymous customer. This is politely referred
to as a "hack."
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / venkadesh
IT IS UNIQUE KEY AND ITS USED FOR COMPARING THE EMPLOYEE DETAILS
Is This Answer Correct ? | 0 Yes | 5 No |
What is sorter transformation?
what is semi-additive fact?where did u used?
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
how the informatica server sorts the strings values in rank transformations?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
What is Java Transformation? what are the uses of it?
i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
what is the size of u r source(like file or table)?
How can we integrate different flat file data in a single mapping and with in a single execution
what is size of u r database?