Interested to Buy Any Domain ? << Click Here >> for more details...
what is surrogate id ?
- 3 Answers
- 8432 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vijaya
surrogate is acts as a primary key. some times we want to
maintain historical information of particular product or
anything. for eg, a product costs 20rs in the month of may
and next month it costs 25rs. in this case if we want to
maintain both records with same product_id then it cant be
possible if product_id is primary key. In this case we use
concept of surrogate key. like
skey prod_id price month
1 101 20 may
2 101 25 june
in informatica this concept is used in update strategy.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mahesh manam
The main purpose of SURROGATE KEY is:
--> If you want to store the multiple records
for example:
In one general store customer id is primary key ,
If the customer change his address or phone number .
But now our requeriment is like to store all the data along
with old
-->If you are using duplicate records with out using
SURROGATE KEY like as follows:
ID NAME LOC
1 Mahesh Chennai
1 Mahesh Hyderabad
In above case if you are work with any dimmension model it
is not support to use this table. So, we need to maintain
Primary Key in each table.
-->Surrogate key is a key in that table use as a primary
key in the table to do joininng to another
-->Surrogate is very usefull and Quickly
If you are using any huge amount of data and you need to
retrive the queries which is usefull to your bussiness
| Is This Answer Correct ? | 0 Yes | 0 No |
without matching columns in two tables. how can you join
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
In Which scenario did u used Incremental loading?
what is the purpose of surrogate key and diff between primary key&surrogate key
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
what is the process we used in joiner transformation,there is no matching column in sources?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Teradata 
