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
What is dimensional table? Explain the different dimensions.
What is the status code in stored procedure transformation?
How we can create indexes after completing the load process?
Which are the different editions of informatica powercenter that are available?
What do you understand by term role-playing dimension?
Where are the source flat files kept before running the session?
where to store informatica rejected data? How to extract the informatica rejected data?
What are different types of transformations available in informatica?
What are the types of lookup transformation?
How to use pmcmd utility command?
Define mapping and session?
How you prepared reports for OLAP?
How do you load only null records into target?
Why update strategy and union transformations are active?
What are the designer tools for creating transformations?
