Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How many numbers of sessions can one group in batches?
What does “tail –f” command do and what is its use as an Informatica admin.
What is expression transformation?
wat are deployement groups in informatica, how it will be used for developers
What is a joiner transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What's the layout of parameter file (what does a parameter file contain?)?
Plz can any one say me how to get the informatica certification materials and dumps
How to create or import flat file definition in to the warehouse designer?
How to update or delete the rows in a target, which do not have key fields?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What are the differences between a connected lookup and unconnected lookup?
difference between informatica 8.1.1 and 8.6
What could be the possible resons of locks by user?
Define mapping and session?
